Category: sql server

Video: Designing Stored Procedure Solutions

Post author By Jen McCown
Post date April 28, 2014
Categories In All Things MidnightDBA, Beginner, Dev, Intermediate, News-ish, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
3 Comments on Video: Designing Stored Procedure Solutions

My new session for 2014, “Designing Stored Procedure Solutions”, is now up on the Sessions page: abstract, video, and code! This month, I gave this session at the Oklahoma City SQL Server User Group‘s 5 year anniversary, and at the Alaska SQL User Group, to thousands and thousands* of attendees and wild** applause. I’m looking […]

GetLogSpace – table and stored procedure

Post author By Jen McCown
Post date March 31, 2014
Categories In Admin, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
3 Comments on GetLogSpace – table and stored procedure

We’ve talked before about how to get log space usage information in SQL Server. After the 1,032nd time I re-wrote my custom query to also see the UNused log space, it occurs to me that this would be a nice thing to have on your server on a permanent basis. Introducing: GetLogSpace! It’s a simple […]

InfoWorld Review: SQL Server 2014, by Sean McCown

Post author By Jen McCown
Post date March 20, 2014
Categories In News, Reviews, sql server, sqlserverpedia-syndication, SSC

InfoWorld Magazine (http://www.InfoWorld.com) has published a new article by MidnightSQL owner Sean McCown, “Review: SQL Server 2014 pushes the pedal to the metal”. The article announces the upcoming release of Microsoft SQL Server 2014 – due out on April 1, 2014 – and reviews some of the top new features. InfoWorld Magazine is “the leading […]