Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.
2018-10-18
4,902 reads
Articles
Using your critical eye to see something positive
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
2018-10-18
71 reads
Creating Machine Learning Applications using Azure Cognitive Services
Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.
2018-10-18
3,009 reads
Using Azure Quickstart Templates
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
2018-10-17
2,544 reads
Using Redgate API to compare data in the same table
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
2018-10-16
1,364 reads
Configuring a MySQL Database on Amazon RDS
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
Being Careful with Schema Ownership
When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.
2018-10-15
14,136 reads
A Primer on Defect Management
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.
2018-10-15
2,216 reads
Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,329 reads
Finding & Fixing Statistics Without Histograms
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
2018-10-12
3,200 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers