JeySoftware

What’s So Bad About Shrinking Databases with DBCC SHRINKDATABASE?

What's So Bad About Shrinking Databases with DBCC SHRINKDATABASE? - Brent Ozar Unlimited® You read a lot of advice that says you shouldn’t shrink databases, but…why? To demonstrate, I’m going to: Create a database Create a ~1GB table with 5M rows in it Put a clustered index on it, and check its fragmentation Look at my database’s empty space Shrink the database to get rid of the ...

My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do?

Q: My SQL Server database shows a very large size, but the sum size of all the tables is nowhere near the size of the database. What should I do? This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Composition over Inheritance

Composition over Inheritance 💖 Support the show by becoming a Patreonhttps://www.patreon.com/funfunfunctionThis is a weekly show where we try to become more confident and excited about ...

Enabling Application Initialization in IIS - SQL Monitor 7 - Product Documentation

Enabling Application Initialization in IIS - SQL Monitor 7 - Product Documentation If you choose to use IIS to host the SQL Monitor web interface, and you wish to make use of the scheduled reporting feature to receive regular reports, then it will be necessary to enable the Application Initialization feature for IIS.

IIS 8.0 Asp.net warm up Auto Start & Application Initialization

IIS 8.0 Asp.net warm up Auto Start & Application Initialization Steps to setup IIS Asp.net Warmup module. Describe usage of Preload- System.Web.Hosting.IProcessHostPreloadClient

Use IIS Application Initialization for keeping ASP.NET Apps alive
Ever want to run

Use IIS Application Initialization for keeping ASP.NET Apps alive Ever want to run a service-like, always-on application inside of ASP.NET instead of creating a Windows Service or running a Console application? Need to make sure that your ASP.NET application is always running and comes up immediately after an Application Pool restart even if nobody hits your site?...

Multiple SQL Server instances with multiple fixed IP addresses on the same server

Multiple SQl Server Instances on Same Server – SQLServerCentral Multiple SQl Server Instances on Same Server – Learn more on the SQLServerCentral forums

Designing matrix reports with RDLC

Designing matrix reports A matrix aggregates data (such as SALES) along two or more dimensions (such as PRODUCT and SALESPERSON) and displays the results in a grid format. Matrices are similar to PivotTables in Excel, and crosstabs in Access.

SQL Server PIVOT

SQL Server PIVOT Operator Explained Clearly By Practical Examples This tutorial shows you step by step how to use the SQL Server PIVOT operator to convert rows to columns.

How to encrypt SQL TDS connections

How to encrypt SQL TDS connections If your SQL clients (for example developers’ SQL Management Studios) and SQL Servers are not really “close” to each other, you should encrypt the tabular data stream (TDS) channel with SSL. First, …

Scheduled Tasks in ASP.NET

Scheduled Tasks in ASP.NET Explains how to simulate scheduled task using ASP.NET only, using Timer, Thread or Cache expiration.