How to Find Out Which Database Object Got Deleted
Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.
2017-08-22
4,419 reads
SQL
2017-06-01
1,021 reads
Validate Integer and Decimal Values in SQL Server
Bhavesh Patel shows how to validate specific use-cases for integer and decimal values in SQL Server.
2017-05-31
3,649 reads
2017-05-30
1,119 reads
Doing Fuzzy Searches in SQL Server
A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.
2017-04-27
7,260 reads
PowerShell 3rd Party tool Memory Alert
Keeps a memory leak under control until the bug fix is developed and applied. Short term band aid.
2017-04-25 (first published: 2017-04-13)
447 reads
2017-04-12
4,608 reads
SQL Login Password Audit
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
2,694 reads
2017-03-21 (first published: 2017-03-15)
409 reads
2017-03-07 (first published: 2017-03-01)
1,019 reads
Blogs
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Forums
combine two interval tables into single result set
Hello, Looking for help combining two interval tables together. The tables are pretty simple......
How can do a loop select stmt from this folowing table
Hi..How can do a loop statement for the following table first loop shld be...
Azure SQL Managed Instance Features
Comments posted to this topic are about the item Azure SQL Managed Instance Features
Ask SSC