SQL Server Hardware and Storage Links
Being a DBA is more than just knowing about SQL: it’s about the technology which SQL runs on, which includes servers and storage. I’m naturally interested in hardware, so...
2013-09-24
12 reads
Blog Posts
SQL Server Internals Presentation with PASS DC Chapter October 10, 2013
If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join...
2013-09-24
520 reads
Why the Lazy Spool Is Bad
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,578 reads
Cumulative update package 6 for SQL Server 2012 SP1
Microsoft has release the CU update package 6 for SQL Server 2012 SP1. To apply this package in your environment,...
2013-09-23
1,331 reads
Encryption and Full Text Search at The Mandalay Bay (DevConnections)
It’s just a week until Dev Connections. This is one of the great conferences for the hybrid technology person, with...
2013-09-23
682 reads
Finding The Active Sharepoint Databases
This was a task from last week. There was a server where we wanted to make some adjustments to security...
2013-09-23
961 reads
Installing SQL Server 2008 on a machine with .NET Framework 4.0? Read this.
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,064 reads
It's Just Another Manic SUNDAY - OT
Warning, this is just a non-technical anecdotal blog of a silly time-warp incident that happened to me yesterday. Thought it...
2013-09-23
875 reads
Last Weeks Top “Reading” Links #50
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-09-23
997 reads
MDX Scope with an If Then statement
The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a...
2013-09-23
1,241 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