Testing Simple Calculations and UDFs with tSQLt
This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.
2015-05-18
5,566 reads
Articles
Documenting your SQL Server Database
One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.
2015-05-18
9,083 reads
SQL Saturday #407 - Vancouver
SQL Saturday is coming to Vancouver, British Columbia on June 27 2015. Join us for a free day of SQL Server training and networking. Register while space is available.
2015-05-18
6,914 reads
Automated Database Deployment Workshop: Belfast, Northern Ireland
Redgate's DLM Workshops are coming to Belfast, NI on June 26, 2015. Learn how to: deploy databases using Redgate's DLM tools, assess the different requirements of production and non-production deployments, and handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.
2015-05-15
7,393 reads
Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow
If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.
2015-05-15
9,082 reads
SQL Saturday #379 - South Florida
Join us for a free day of SQL Server training and networking in Davie, Florida on June 13, 2015. Admittance to this event is free, so register while space is available.
2015-05-14
6,155 reads
T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements
Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.
2015-05-14
11,622 reads
How to Get SQL Server Security Horribly Wrong
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.
2015-05-13
9,527 reads
The Case for Scalar-valued, User-defined Functions in T-SQL
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
2015-05-12
7,267 reads
How do you work with databases?
How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.
2015-05-12 (first published: 2015-05-05)
19,487 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers