Blog Posts

Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...

2017-01-12 (first published: 2017-01-05)

1,307 reads

SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)

by Prashanth Jayaram

PowerSQL By Prashanth Jayaram

Table of Contents
Problem Statement:-Solution:-Generate script for matching search string of all SP’s
Using sp_helptextUsing system view sys.proceduresGenerate modified SP’s scriptCreate Linked...

2017-01-12

1,351 reads

Using the PowerShell SQL Provider with SQL Authentication

by Rob Sewell

SQL DBA With A Beard

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,059 reads

Vote for @SQLBits Sessions (pick me, pick me)

by Steve Jones

SQLServerCentral Blogs

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

by Steve Jones

SQLServerCentral Blogs

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,564 reads

Why won’t my SQL Logins work?

by Kenneth Fisher

SQLStudies

I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a...

2017-01-12

814 reads

Documenting databases

by endizhupani

xSQL blog

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

37 reads

I used to shrink my databases!

by Arun Sirpal

All About SQL

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

824 reads