Misc Reading for September 12, 2012
Sharing some stuff I’ve read recently that I found interesting – and that you may find interesting!
Help More, Judge Less. I’ll...
2012-09-12
663 reads
Blog Posts
New Laptop Bag and My Event Bag
Last year I wrote about stuff I carry in my laptop bag. Nothing original, definitely a tendency to carry things...
2012-09-12
1,217 reads
Pearls in the Ocean – Part 1
In our day to day life with SQL Server, We refer web for many reasons.
This includes understanding new SQL...
2012-09-12
808 reads
Sometimes Failure Is An Option
Wouldn’t it be nice if failure was an option? You could go along in life, screw it all up and...
2012-09-12
772 reads
SQL Server Virtualization
This past summer I have been working on a new course for Learning Tree 2109 SQL Server Virtualization and Consolidation:...
2012-09-12
998 reads
SQL Server: Understanding GAM and SGAM Pages
We know that SQL server stores the data in 8 KB pages. An extent is made up of 8 physically contiguous...
2012-09-12
26,715 reads
Why do you attend sessions?
Many of you have attended sessions by technical speakers at conferences and mini-conferences like SQL Saturday, SQL Rally, 24 Hours...
2012-09-12
1,097 reads
Find Skew in Distributed Tables
The SQL Server PDW (Parallel Data Warehouse) is a beast of a machine. Spreading workload across multiple nodes inside the...
2012-09-11
1,524 reads
Going to San Diego (#SQLSat157)
It appears that I signed up to speak at the San Diego SQL Saturday coming up this weekend. I knew...
2012-09-11
694 reads
Quick tip: Querying database metadata with DBCC DBINFO
Page 9 in file 1 (of the primary filegroup) in a SQL Server database is the header page and contains...
2012-09-11
2,133 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
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
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?...
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