Why I Developed SQL Code Guard: A Fairy Tale from a DBA
This is the story of how a free addin for SSMS, SQL Code Guard, was created and joined the Red Gate SSMS Ecosystem project.
2014-03-10
5,251 reads
Articles
Automate Sliding Window Partition Management: Part I
A new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.
2014-03-07 (first published: 2010-12-14)
19,724 reads
Adding SQL Server AlwaysOn to existing Failover Clusters
We have a SQL Failover Cluster Instance in our primary data center, and want to implement a second two node Failover Cluster Instance in our secondary data center. A new two node cluster located in our secondary data center was setup, but I could not create a new High Availability Group between the two failover cluster instances. What went wrong?
2014-03-07
3,721 reads
SQL Saturday #275 - Copenhagen
SQL Saturday is coming to Denmark on March 29, 2014. This a free event of SQL Server training and networking. The full schedule is up (and it's full of great speakers) on the SQL Saturday site and make sure to say hello at the Red Gate booth while you're there.
2014-03-07
1,542 reads
One size does not fill all
Allowing your application to generate your SQL can be a really bad decision.
2014-03-06
191 reads
Big Data: Integration with Little Data
If we want to incorporate big data into our enterprise, it's crucial to know how to integrate it with our existing data.
2014-03-06
5,076 reads
Vote Now: Final Service Packs for 2008/2008 R2
Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.
2014-03-06 (first published: 2014-02-28)
4,471 reads
Junk Drawer
Dale Newman created open source project called Junk Drawer. It's goal is to make the majority of Excel or text file importing a one step, no-brainer process without using the Import Wizard.
2014-03-05
3,095 reads
Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization
Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe case of 'Cache Bloat' due to ad-hoc queries, but you can't fix the code itself. What should you do? Specify forced parameterization? Perhaps a better idea would be to use guide plans.
2014-03-04
2,646 reads
SQLSaturday #269: SQL South West, Exeter, UK
SQL South West user group are running their second SQL Saturday on March 21st and 22nd and have another spectacular schedule of technical content from SQL Server professionals from the UK, Europe and USA including SQL Server MVPs and Microsoft staff. All the session details and how to register for the full-day pre-con sessions or the free-to-attend Saturday:
2014-03-04
1,702 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
How Well Does the MSSQL Extension in VSCode Work?
Comments posted to this topic are about the item How Well Does the MSSQL...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers