How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.
2011-10-25
2,854 reads
Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.
2011-10-24
3,952 reads
Come to SQL in the City, Friday Oct 28, in Los Angeles and meet Grant Fritchey, Brad McGehee and Steve Jones among others. A day of free training for SQL Server professionals.
2011-10-24 (first published: 2011-10-21)
2,347 reads
Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you’re a DBA or developer, there are plenty of times when a CLR routine will save a lot of time, and occasionally provide new functionality.
2011-10-24
4,490 reads
This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.
2011-10-21
2,992 reads
A data flow task generated by the SSIS Import and Export Wizard can be configured to extract data from multiple files by changing the default connection manager to a MultiFlatFileConnection.
2011-10-20
4,917 reads
A tale from the days when civilization was young and everything was harder than it is now.
2011-10-20 (first published: 2009-12-30)
10,730 reads
Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.
2011-10-20
2,823 reads
On Thursday October 20th ,MVP Louis Davidson will discuss the why normalized databases are the most important part of query tuning
2011-10-20
1,698 reads
A lively comparison of Pascal's triangle to root cause analysis from David Poole.
2011-10-19
4,515 reads
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Comments posted to this topic are about the item Having a Little Fun at...
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers