Back Yourself Up
Ever thought about yourself as a resource that should be backed up to minimize your loss?
2018-09-05
90 reads
Hakim Ali
Birds of a Feather
What makes SQL Server professionals stick together? Can we draw any conclusions from this?
2017-07-10
132 reads
Two Approaches to Addressing Circular References in SSDT
Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation.
2017-06-12
12,116 reads
What Kind of DBA Are You?
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
2015-09-07
307 reads
A Complex Database Project in Visual Studio SSDT
One Way to Handle a Very Complex Database Project with Several Databases and Cross References
2015-05-19
12,060 reads
2013-07-26
610 reads
Tables and Clustered Indexes Part 2
A table does not so much 'have' a clustered index as a table 'is' a clustered index.
2013-07-22
6,514 reads
Universal Product Codes: a Database Primer
An introduction to Universal Product Codes with code to help you use them in your database.
2013-02-28
6,582 reads
Can a Table Really Have a Clustered Index?
A table doesn't so much "have" a clustered index as a table "is" a clustered index.
2012-12-24
8,368 reads
Code Reviews Must Be Brutally Honest
Today we have a guest editorial from Hakim Ali. Today Akim talks about why holding back out of politeness in code reviews may be a self-defeating practice.
2012-08-06
355 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers