SQL Server VM Best Practices
In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.
2021-09-27
SQL Server
SQL Server identity column
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.
2021-09-13
Disable or Enable All SQL Server Agent Jobs
In this article we look at a PowerShell script that you can use to centrally enable and disable any SQL Server Agent Job on any instance of SQL Server.
2021-09-08
Register Now For PASS Data Community Summit 2021
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
2021-09-10 (first published: 2021-09-03)
Create, Populate, and Subset a Pandas Dataframe from a CSV File
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
2021-09-03
Join SQL Server tables where columns include NULL values
Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.
2021-09-01
Executing a TSQL batch multiple times using GO
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
Issues with SQL Server Permissions to Restore a Database
In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
2021-08-23
Testing SQL Server Databases Using SQL Test
During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
2021-08-20
Improving performance with instant file initialization
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
Blogs
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Forums
Storing a text file in a VARCHAR(MAX) column
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Ask SSC