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.
2018-10-03
2,545 reads
Additional Articles
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.
2018-10-02
3,526 reads
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
2018-10-01
2,535 reads
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.
2018-10-01
2,109 reads
Forwarded Fetches and Bookmark Lookups
If someone says clustered indexes slow you down, they haven't read this.
2018-09-28
2,418 reads
What's New in the First Public CTP of SQL Server 2019
In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.
2018-09-28
3,220 reads
Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset
Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem.
2018-09-27
3,563 reads
SQL Server MERGE statement usage and examples
In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.
2018-09-26
3,483 reads
Adaptive Query Processing in SQL Server
Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.
2018-09-25
2,801 reads
Questions About HIPAA That You Were Too Shy to Ask
As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask.
2018-09-24
2,261 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers