Using the PowerShell SQL Provider with SQL Authentication
Whilst having a conversation with Chrissy LeMaire last week about using the SQL Provider. She asked if it could use SQL...
2017-01-12
2,041 reads
Blog Posts
Vote for @SQLBits Sessions (pick me, pick me)
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...
2017-01-12
464 reads
Watch the Manual DBA v Automated Deployment Challenge
At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...
2017-01-12 (first published: 2017-01-05)
1,563 reads
Why won’t my SQL Logins work?
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...
2017-01-12
813 reads
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
25 reads
I used to shrink my databases!
This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...
2017-01-11
822 reads
Killing databases in SQL Server on Linux
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on...
2017-01-11
1,013 reads
More #SQLintheCity–Behind the Scenes
I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live...
2017-01-11
550 reads
SQL Server Service Information
DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...
2017-01-11
380 reads
Tables can't be compared
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and the messages on the output window show something like [16:08:11]...
2017-01-11
13 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
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...
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