The Wizard enables anyone working with a SQL Server database to identify and review duplicate data with ease. It is an exceptionally powerful tool with the modest price tag of $397 (approximately £230).
The software has a wealth of processing options, which you can read about when visiting www.findduplicates.com or (in even more detail) in the free help file download which is also available on the web site.
Joseph gathered together some various bits of code and came up with a solution that lets you do RC4 encryption via the sp_oa~ procedures.
Are you using alerts to help you keep track of things? Are you using as many alerts as you should be? Jeremy has a great list of alerts that he considers so important they are on his 'best practice' list. Definitely worth reading.
Ramesh writes about various indexing strategies that you might use to improve performance.
David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.
Haidong continues to point out ideas that might get you thinking about ways you can do more administration with less work. In this article he demonstrates a couple useful tasks you can do with xp_cmdshell.
New Author! This is an introductory level look at MDX geared toward intermediate or higher SQL users. The rate of OLAP usage is lower than it should be - maybe this will be what gets you started using it. Or thinking about it at least!
Hopefully you never hear any of these from your sysadmin...
Ever wonder how SQL Server Central.com was built? Ever wonder why the three founders made the decisions they did? Here's a look at some of the choices that were made early on with the discussion forums.
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
I just learned that my database was created on my C:\ drive in the...
I am needing to migrate a MSSQL db to MySQL, on a different server...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers