SQL Homework – December 2017 – View the log
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
316 reads
SQLStudies
SQL Puzzle – Word Scrambler
I’ve been writing crosswords for the last few months and to change things up I thought I would do a...
2017-11-29
564 reads
Closing all of the connections to a database
Doing a database restore may not be the most common task a database professional will ever do, but it’s a...
2017-12-07 (first published: 2017-11-27)
6,859 reads
Why shouldn’t I shrink my database data file?
A while back I did a post about why you shouldn’t shrink your data file. This one is going to...
2017-11-20
465 reads
Variables in Dynamic SQL
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement....
2017-11-16
1,498 reads
It takes a village
Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten...
2017-11-14
338 reads
More Collation Confusion. (tempdb)
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
420 reads
DBA Definitions: FILLFACTOR
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
549 reads
SQL Homework Nov 2017: Create a view
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they...
2017-11-13 (first published: 2017-11-01)
1,516 reads
Haunted SQL: The ghost of Management Studio
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
675 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
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...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
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