My new course “LFCE: Advanced Network and System Administration” in now available on Pluralsight here! If you want to learn about the course,...

2017-01-13

689 reads

Friday Reading 2017-01-13

by Andrew Pruski

The DBA Who Came In From The Cold

Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…
A whole day of PowerShell & SQL

Join...

2017-01-13

347 reads

Checking Time Zones in SQL Server

by Arun Sirpal

All About SQL

I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...

2017-01-13

1,330 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,350 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

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

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

Tables can't be compared

by endizhupani

xSQL blog

"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

16 reads