PowerShell Usage in DBA Work – Case Study 7/7
Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...
2013-03-29 (first published: 2013-03-24)
2,606 reads
PowerShell Usage in DBA Work – Case Study 6/7
SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...
2013-03-27 (first published: 2013-03-23)
2,721 reads
MDX #28– Time functions will not work with subquery
I had a post last month, MDX #25 – Slicer or Sub-Cube?, verifying that the query context did not change with...
2013-03-22
1,253 reads
Macbook Air v Surface Pro
I love my MacBook Air. It’s small, light, and it works well as a traveling laptop for me. It starts...
2013-03-22
1,733 reads
Fargo SQL Saturday (#SQLSat175) Schedule Is Up
It’s just coming up in just a few more weeks… this is the first SQL Saturday in Fargo. North Dakota...
2013-03-22
625 reads
Reblog: March 15 to March 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-22
666 reads
April 2013 Events
April is going to be a fantastic month! I am slated to have quite a few speaking and training opportunities...
2013-03-22
675 reads
Sub query pass through
Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...
2013-03-26 (first published: 2013-03-22)
3,587 reads
We Need a Place for SQLFamily News
I’m writing this because I was thinking about a member of the local PASS chapter on the way home last...
2013-03-29 (first published: 2013-03-22)
1,202 reads
Why I’m Considering a Surface and Windows Phone 8
Anyone who knows me will see the title of this post and tell you I’m about to trash the Surface,...
2013-03-22
677 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers