A Lack of SQL
Steve Jones talks about a company looking to write all their stored procedures using the CLR in SQL Server. Is this a good idea?
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
Moving Indexes
Working with filegroups and managing the location of your various objects can be a cumbersome task in SQL Server. New author Thom Bolin brings us a technique and some code that worked well for one of his clients.
How To Collect Performance Data With TYPEPERF.EXE
One of the things I typically need to do is to collect performance data on the server which includes CPU, memory and disk utilization as well as SQL Server-specific data. What command line tools are available to do this?
Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?
Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing. The following corollaries to Murphy’s Law relate this inevitability of something going “bump” in the night to data warehousing.
The Broken Window
A new data mining thrilled from Jeffrey Deaver has Steve Jones concerned about the centralization of data mining.
The Broken Window
A new data mining thrilled from Jeffrey Deaver has Steve Jones concerned about the centralization of data mining.
The Broken Window
A new data mining thrilled from Jeffrey Deaver has Steve Jones concerned about the centralization of data mining.
The Fall vConference Series
A series of online conferences covering various aspects of SQL Server and other Microsoft technologies. Check out the list for this fall and see if there is some training that you can attend.
A Lack of SQL
Steve Jones talks about a company looking to write all their stored procedures using the CLR in SQL Server. Is this a good idea?
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