Moving PASS
The PASS Summit has been held in Seattle for a number of years, but recently people have asked to move it somewhere else. Steve Jones talks a little about the issue.
The End of Support
It can be nerve-wracking for a DBA when support for their server ends. This week support for SQL Server 2005 Service Pack 2 ended and Steve Jones talks about your options.
Implement a stack in SQL Server using stored procedures
In this article I will show you how to implement a stack. In programming, stacks are a great way to...
Improving Data Compression Fidelity Without Sacrificing Speed
Making it easier to handle huge data sets
Local Temporary Tables and Table Variables
Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.
The Price of SQL Server
SQL Server is an expensive product to license. Or is it? Steve Jones asks today if you feel it's expensive, and what price might you want to pay.
Database Indexing Development Lifecycle...Say What?
Creating good indexes on your database doesn't happen by mistake--you need to have a plan. Greg Larsen shows you how, beginning with a discussion on the indexing development lifecycle.
House of Commons Justice Committee Related to The European Union's Data Protection-Retention Directives
Just this past week on Tuesday afternoon, U.K. Information Commissioner Christopher Graham spoke in the Wilson Room for the House...
A Genetic Algorithm Sample in T-SQL
Bill Talada brings us an interesting use of T-SQL. Imagine you have a robot moving around a grid and it needs to complete various actions. How do you find the smart robots across many generations?
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