SQLServer Log Shipping Work File ! What is this all about ?
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,282 reads
SQLSailor.com
CU3 for SQL2012 SP1 – Couple of interesting hotfixes.
Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from
http://support.microsoft.com/kb/2812412
Similar to CU2 there...
2013-03-21
1,438 reads
Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,458 reads
Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,937 reads
Get Database information in mail using PowerShell !
Would you love to get a weekly status report of all the databases hosted on your mission critical servers? ,Would...
2013-02-26
1,940 reads
Check the version of Windows Installer !
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why...
2013-02-09
1,216 reads
Quick alert on servers which are not compliant for policies set using PBM
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...
2013-02-06
813 reads
Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new...
2013-01-17
1,046 reads
DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...
2013-01-11
3,297 reads
SQLAgent Job related reports and out of box real time job monitoring tool !
Lets start New Year with a very simple yet useful topic.
I am a big fan of out of box reporting...
2013-01-08
1,266 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