Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

2017-10-18

541 reads

Connecting to a Remote Instance of SQL Server Using Python

by davidfowler-42596

SQL Undercover

SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...

2017-10-18

1,206 reads

The perils of RAID

by Randolph West

Born SQL with Randolph West

Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...

2017-10-18

649 reads

Does Your Code Have a Preamble?

by Monica Rathbun

SQLEspresso

Okay, here is a pet peeve of mine, I think every stored procedure, function, view etc. should all contain a...

2017-10-18

498 reads

And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!

by Andy Galbraith

Nebraska SQL from @DBA_ANDY

https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...

2017-10-26 (first published: 2017-10-18)

3,587 reads

Updateable CTEs

by Kenneth Fisher

SQLStudies

CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t...

2017-10-18

1,970 reads

Are your disks formatted with UseLargeFRS?

by Cody-Konior

Cody Konior

PureStorage has a pretty cool post that mentions the importance of formatting SQL Server disks with a 64KB clusters and...

2017-10-18

2,738 reads

Linked Servers and Stats

by Jason Brimhall

SQL RNNR

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for...

2017-10-17

244 reads