SQL Server vs. Oracle
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,026 reads
Azure Virtual Machine TempDb Placement
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...
2012-09-06
2,087 reads
Introduction to Windows Azure SQL Database Services (Part 2)
In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...
2012-09-06
1,259 reads
SQLskills joining Pluralsight is a good news for all
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,093 reads
Meet Thomas Kejser in Aarhus
This is normally not a place where we advertise for events held by our friends, but today I’ll make an...
2012-09-06
778 reads
This is Big Data
I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...
2012-09-06
985 reads
Demystifying SQL Server Differential Database Backups
Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...
2012-09-10 (first published: 2012-09-06)
2,822 reads
Stressed? Need training? Take a #SQLCruise!
I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...
2012-09-06
986 reads
DBCC Cleaning CACHE – Memory
DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know...
2012-09-06
962 reads
Installing SQLServer for SCCM 2012 – Some points to note on patch levels
The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)
For...
2012-09-05
1,703 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers