With the improvements in the Windows Server 2012 implementation it’s now feasible to install SQL Server on SMB network shares. This applies to both standalone SQL server installations as well as clustered SQL Server installation. Before that, it was possible with the use of trace flag 1807 but this was never a desired configuration. However, […]
Read More
There’s no doubt that SQL Server Management Studio (SSMS) is the SQL Server DBA’s best friend and most frequently used tool. However, while everyone knows the basics of how to use SSMS to navigate through database objects as well as write and run queries there’s a lot of other functionality that’s built into SSMS that […]
Read More
With the world moving to cloud, one of the major concerns for the SQL Server Database Administrators (DBAs) is performance of SQL Server running on virtual machine (VM) as compare to an on-premises machine. In case of on-premises machine, hardware is owned by company but on the other hand, in case of IaaS, the hardware, […]
Read More
Learning something completely new can pose as a challenge. This is something I have always felt when working with SQL Server. Till about 3-4 years back, I used to be so comfortable with TSQL that I was looking for things people were learning. That is the timeframe when I was introduced to the world of […]
Read More
By now it’s pretty common knowledge that PowerShell is Microsoft’s preferred management tool and over the past few years, they have really extended the capabilities of PowerShell to where it can be used for just about every management task. There are even some things that can only be done in PowerShell. Even so, PowerShell is […]
Read More
Scheduling jobs is one of the core SQL Server functions. Many businesses have numerous SQL Server jobs scheduled that perform any number of different tasks from database maintenance jobs like backup and index rebuilds to running queries and kicking off ETL tasks. The SQL Agent is the SQL Server subsystem that’s responsible for automatic task […]
Read More
Deploying SQL Server manually can be a lengthy and potentially error prone process as you work through all the different setup screens presented by the SQL Server Installation Center. If you want a standardized installation you need to be careful to enter all of the values the same every time. Plus, the installation process is […]
Read More
Beginning back with SQL Server® 2005, Microsoft® integrated the .NET runtime into the database engine. This runtime engine is called the SQL Server Common Language Runtime (CLR), and is commonly referred to as SQLCLR. SQL Server CLR enables you to extend the capabilities of the SQL Server database engine with the rich programming environment of […]
Read More
This article provides detailed information on Foreign Keys in SQL Server. Get a free Stored Procedure to find Foreign Keys in a child table.
Read More
Foreign keys have a bad reputation, but here you can learn how they can benefit and even improve query performance.
Read More