Getting More Hardware Information from SQL Server Denali DMV Queries
As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly....
2011-04-06
2,691 reads
Glenn Berry
A SQL Server Hardware Nugget A Day – Day 6
For Day 6 of this series, I am going to talk about a few useful tools you can use to...
2011-04-06
391 reads
Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali
I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL...
2011-04-05
599 reads
A SQL Server Hardware Nugget A Day – Day 5
For Day 5, I will be covering a few tools that can be used for hardware identification. Since quite a...
2011-04-05
600 reads
A SQL Server Hardware Nugget A Day – Day 4
Day 4 of this series is about the upcoming AMD “Bulldozer” family of processors that is due to be released...
2011-04-04
374 reads
A SQL Server Hardware Nugget A Day – Day 3
Lest anyone accuse me of ignoring AMD in this series, I will talk about the AMD Opteron 6100 series processors...
2011-04-03
447 reads
A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
537 reads
A SQL Server Hardware Nugget A Day – Day 1
Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV...
2011-04-02
411 reads
Intel Sandy Bridge Mobile Processors Explained
The long wait for the new, mobile Sandy Bridge processor equipped laptops is nearly over. Most of the large system...
2011-03-24
1,107 reads
Presenting To Columbus SQL Server User’s Group on April 14
I will be doing a live, virtual presentation for the Columbus, Ohio SQL Server User’s Group on Thursday, April 14....
2011-03-23
784 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers