Are Indexes Actually Changes to the System?
Is an index change equivalent to a code change? Steve Jones asks the question and has a few thoughts.
2018-10-02
143 reads
Editorials
Give Up on Natural Primary Keys
With the need to remove older data, Steve thinks natural keys may be obsolete.
2018-10-01
199 reads
The Ever Expanding Data Platform
With lots of news coming out of Ignite, Steve talks about a few of the changes.
2018-10-01
42 reads
Picking the Right Type of Tool For the Job
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
2018-09-28
48 reads
An Open Thank You to the Microsoft SQL Server Team
Thanks for improving the string or binary data truncated error message.
2018-09-27
162 reads
The Uninteresting But Necessary Work
Data classification may not be fun or even interesting, but it is necessary.
2018-09-26
65 reads
2018-09-24
134 reads
2018-09-24
68 reads
2018-09-20
50 reads
2018-09-19
91 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers