For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.
2013-03-08 (first published: 2011-03-24)
24,402 reads
In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.
2013-03-08
6,789 reads
The MERGE statement is powerful and multifunctional, yet it can be hard to master. SOmetimes the MERGE statement that just doesn't do what it's needed to do, like process a Type 2 slowly-changing dimension. Check out this tip to learn more.
2013-03-08
3,847 reads
The focus of this paper is on the protection of PII data stored within a database using encryption technologies.
2013-03-07
1,824 reads
A short look at the vulnerabilities your data may be susceptible to outside of the database tables.
2013-03-07
6,290 reads
SQL Server isn't usually the best place to format dates or currency as strings. It can be a complex task to conform correctly with national and cultural conventions. Just occasionally, though, you need to do it. This is easy in SQL Server 2012, but if you aren't using that, what do you do?
2013-03-07
2,201 reads
A day of SQL Server training in the UK on Mar 9, 2013. Sign up if you can come.
2013-03-06
1,751 reads
emporary tables are created in the Temporary tables are created in the TempDB database, which persists for a particular session. The objective is to maintain that session, until the temp table information is used and dump the data into a physical table.
2013-03-06
4,197 reads
The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,
2013-03-05
3,616 reads
Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.
2013-03-05
3,607 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers