Data We Don't Want
There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.
Working with SQL Server Recovery Models
The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,
An Incremental Database Development and Deployment Framework
Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.
Data Loss
A new study shows potential corruption issues with solid state drives when power is cut under a load. That can have implications for data professionals as more databases incorporate SSD storage.
How to move a SQL Server Log Shipped Secondary Database to Different SQL Server
This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.
SQL Saturday #187 - Richmond
A free day of training in Richmond, VA. Come along and see Steve Jones, Grant Fritchey and more.
New Free Event for Database Professionals in Virginia
SQL Server developers and database administrators have the chance to attend a free half-day event, in Richmond, VA - hosted by SQL Server experts Steve Jones and Grant Fritchey.
Using a Variable for an IN Predicate
How to use a passed string variable for an IN type predicate in your queries as a way to more efficiently handle an array of strings.
Why SQL Server?
This Friday Steve Jones asks you how you got started working with SQL Server in your career? Let us know how you got started and why you stuck with it.
SQL Server Statistics Questions We Were Too Shy to Ask
If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers