Connection options in SSMS
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...
2013-11-18
1,626 reads
Blog Posts
Fill Factor, Why Do You Taunt Me? Part 2
So Friday we were discussing the idea of an idea. I think... or an idea of an idea's idea. What...
2013-11-18
1,000 reads
For the Aspiring DBA
Getting started as a data professional is an incredibly daunting task. If you’re not concerned that you’re going to mess...
2013-11-18 (first published: 2013-11-11)
1,487 reads
I’m speaking at SQL Server Saturday #233 – Washington DC!
It’s that time of the year again when SQL Saturday makes its way back to the Washington DC Area. Here...
2013-11-18
589 reads
Last Weeks Top “Reading” Links #58
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-11-18
923 reads
MDX+SSRS #33 – Retrieve manager’s key and fully-qualified member name
A co-worker recently worked on a SSRS report and wanted to use a specific manager’s team for testing. The Manager...
2013-11-18 (first published: 2013-11-08)
2,341 reads
Power Pivot Synonyms
A little gem was included with the latest Office 365 update. After downloading and installing this update you will now find...
2013-11-18
936 reads
SQL Saturday in Verona – Slide deck of “Put databases under source control” available for download
“Put databases under source control” slide deck is available here. The SQL Saturday – Verona event was a great success. Now we’re waiting for...
2013-11-18
478 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
4,343 reads
SQL Server – Custom sorting in ORDER BY clause
ORDER BY clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the...
2013-11-18
428 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
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