SQL Server Logon Trigger Examples
In this tip we look at how to create SQL Server Logon Triggers and show different examples of how this can be used.
2019-08-15
Articles
Find SQL Server Integer Columns to Make Skinnier
In this tip we look at a SQL Server script you can use to determine if you can convert your big integer columns to smaller integer data types to save storage space.
2019-08-14
How to stop standardization being a stumbling block in database DevOps
Redgate's Heath Tull discusses ways to standardize team-based development with database DevOps, avoiding standardization as a stumbling block.
2019-08-14
2019-08-13
2,763 reads
Redgate Takes over the SQLCop Project
I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]
2019-08-13
3,915 reads
Executing Dynamic SQL Using sp_executesql
Learn how to create and execute dynamic SQL in your SQL Server projects!
2019-08-13
How to convince your boss you need SQL Server monitoring
You’ve read the State of SQL Server Monitoring Report and you’ve decided you need a SQL Server monitoring tool to cover your estate fully. Now you just need to convince your boss to get on board. Read our blog to find out how to do it.
2019-08-13
Dynamic SQL for beginners in 33 minutes
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
8,647 reads
How to boost team productivity with SQL Clone 4
Wednesday August 21 16.00-17.00 BST/ 10.00-11.00 Central - SQL Clone enables dev, test and CI environments to be created and refreshed in seconds, on demand or through self-service, with the latest copy of production data, masked for compliance.
2019-08-12
Measuring the Right Things
In this weeks Simple Talk editorial Kathi Kellenberger discusses how to measure the performance of a development team and why you should always make sure you are measuring the right thing, not just the easy thing.
2019-08-12
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers