SQL Server vs. JET
This past week the Exchange 2010 team admitted they had tried SQL Server as a storage platform for Exchange 2010, but then discarded it. Steve Jones wonders why this was the case. Is SQL Server not good enough?
Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
Certification High School
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
Help Me Name My New Blog
I am in the process of creating a new blog, but I am having difficulty coming up with a good name. I would like to go with a Hawaii-based theme on the blog, so a Hawaii-based name would be great.
Retaining historical index usage statistics for SQL Server - Part 3
In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.
Using the Resource Governor
SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.
A Deadlock Occurrence and Resolution
This article gives an example of a deadlock occurrence and the resolution steps taken. (Republished from 2008).
Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers