Review: SQL Server Transaction Log Management
Book Details:
SQL Server Transaction Log Management
Davis, Tony and Shaw, Gail
Simple Talk Publishing, October 2012.
Free PDF download
Do I Recommend This Book?
Yes,...
2013-10-28
2,894 reads
Blog Posts
SQL PASS Summit 2013 – Simply Amazing
This past week I attended my third SQL PASS Summit in Charlotte, North Carolina. All I can say is – WOW....
2013-10-28
819 reads
SQL Saturday in Verona!
This year I will speak at PASSSQL Saturday in Verona with a session based on database and source control management.
“PASS SQLSaturday’s...
2013-10-28
332 reads
IT Pro Camp Tampa 2013
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
889 reads
My PASS Summit 2013 Presentations
I had the honor to speak for the first time at this past PASS Summit 2013 in Charlotte, NC. It...
2013-10-27
850 reads
Cumulative SUM in SQL Server
Sometimes we need to find sum of first and next row in cumulative way.
Create table and insert data:
CREATE TABLE [dbo].[testsum](
...
2013-10-25 (first published: 2013-10-19)
41,466 reads
Reblog: October 18 to October 24
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-25
959 reads
Understanding the PIVOT function
The PIVOT function is very useful but not easily understood at first. I thank Itzik Ben-Gan, Dejan Sarka and Ron...
2013-10-25
3,105 reads
Architecture Reasons for Putting BLOBs in the Database
I was participating in a Twitter Chat looking at what suggestions and recommendations for developer on how to make the...
2013-10-24
5,025 reads
MDX #32 – Vincent Rainardi’s blog
I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...
2013-10-24
912 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