Do you test your SQL?
Red Gate is doing some research into SQL testing tools. If you can spare a moment to complete a short survey, or if you're interested in being part of the early access program, please click here.
2011-11-03
2,646 reads
Articles
New Spatial Features in SQL Server Code-Named 'Denali'
SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.
2011-11-03
2,943 reads
Database recovery model change notification report for SQL Server
The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a database recovery model is different than what it is expected.
2011-11-02
2,506 reads
SSMS Tools Pack 2.0
If you work with SSMS, you’ll know how frustrating it can be when tasks you perform every day aren’t part of the core features. Malden Prajdic certainly did, which is why he developed his free SSMS Tools Pack. Now on its second version, Grant Fritchey explains the functionality of this great free plugin.
2011-11-02
4,349 reads
Field Level Auditing using Change Data Capture - Part 1
A two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports.
2011-11-01
8,163 reads
2011-11-01 (first published: 2010-01-27)
10,663 reads
Using a Clustered Index to Solve a SQL Server Deadlock Issue
At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications receiving this dreaded error
2011-11-01
4,839 reads
TSQL Challenge 68 - Generate kaprekar kernel or series from numbers
This challenge invites you to Generate kaprekar kernel or series from numbers.
2011-10-31
883 reads
Using The Kimball Dimensional Modeling Tool
Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.
2011-10-31
8,993 reads
Standardize SQL Server Installations with Configuration Files
If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.
2011-10-31
3,704 reads
Blogs
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Forums
Kantor BCA Finance pusat Tlpn/wa0853.7373-7551
Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...
BCA Finance WTC Mangga Dua Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL,...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers