Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
In this tip look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
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.
Who's Using the DAC?
Learn how you can determine which connection is using the Dedicated Administrator Connection.
Modern Data Warehouse Design Pattern – Part II
Join Anoop Kumar as he discusses two modern design patterns to handle Advanced Analytics on big data, and Real time analytics.
Compress and Decompress in SQL Server 2016
Explore using Compress/Decompress with varying types of data and examine size/storage usage
Give Up on Natural Primary Keys
With the need to remove older data, Steve thinks natural keys may be obsolete.
The Ever Expanding Data Platform
With lots of news coming out of Ignite, Steve talks about a few of the changes.
Exhuming the GDPR Bodies
Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares
Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
In this tip we look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
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.
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