Managed IT Services provider Claranet turned to Redgate after having issues with their old monitoring solution and haven’t looked back since. With SQL Monitor named most popular third-party monitoring tool in this years State of SQL Server Monitoring report, see how it helps Claranet deliver more with less.
2019-08-15
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
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
Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.
2019-08-14 (first published: 2014-02-26)
82,179 reads
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
1,803 reads
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
2,652 reads
Learn how to create and execute dynamic SQL in your SQL Server projects!
2019-08-13
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
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
5,964 reads
By damianwidera
I have delivered a preconf on the biggest conference in Asia. The preconf was...
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
Hello All, We have recently migrated SQL2012 express edition to SQL 2017 express edition...
Ask SSC