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,901 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
335 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
899 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
856 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,472 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
962 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,109 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,040 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
913 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers