Data Compression in SQL Server – Pros and Cons
SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...
2016-05-10
26 reads
Blog Posts
Getting your Cloud on
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...
2016-05-10
500 reads
Power BI and the Bing Maps API
This week I was working on a project for a school up North. This customer wanted to use Power BI...
2016-05-10 (first published: 2016-04-26)
4,196 reads
Virtual SQL Servers, Actual Performance – PASS Virtualization VC Presentation
Tomorrow I’ll be presenting a new session for the PASSVirtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at...
2016-05-10
560 reads
Wait Types and Latch Classes Library
Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...
2016-05-10
278 reads
Common uses of stored Procedure sp_MSforeachtable
We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.
sp_MSforeachtable can be used to loop through all...
2016-05-09
11,516 reads
Events I Wish PASS Organized
I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...
2016-05-09
1,129 reads
Interview with Warwick Rudd
Part of traveling to various events and being a part of the SQL Community means one can meet some pretty...
2016-05-09 (first published: 2016-04-26)
1,008 reads
Monday Morning SQL Break – May 9, 2016
It’s Monday morning (er afternoon) and it’s time for this week’s blog and twitter round-up for last week. If you...
2016-05-09
492 reads
Notes From SQLSaturday Jacksonville 2016
Everything ran smooth The site reminds me of Orlando – limited space for sponsors, but offset by the other advantages (free...
2016-05-09
524 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers