How to Restore Model Database in SQL Server
In this tip we look at how to restore a missing or corrupt SQL Server model database.
2019-12-23
Additional Articles
SQL Prompt by Keyboard
Phil Factor shares a handy keyboard shortcut diagram that reveals some of the most useful of Prompt's keyboard shortcuts, and a wallchart showing every piece of Prompt functionality, what it does, where to find it in the various menus, and of course its keyboard shortcut.
2019-12-23
Controlling how SQL Prompt Formats your Code: The Knobs and Dials
Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.
2019-12-20
Overview of Azure SQL Database Networking
Learn about the range of connectivity options available for Azure SQL Database deployments.
2019-12-20
Memory-Optimized TempDB Metadata in SQL Server 2019
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
2019-12-19
Redgate acknowledged as a Representative Vendor in Gartner’s 2019 Market Guide for Data Masking
Data Masking is key to providing realistic test data for DevOps teams while ensuring compliance with GDPR, CCPA, HIPAA and other regulations. Gartner recently published their 2019 Market Guide for Data Masking covering their analysis, recommendations, and Representative Vendors – including Redgate. Get the Complimentary Report.
2019-12-19
A Beginner’s Guide to SQL String Functions
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
2019-12-18
Take the 2020 State of Database DevOps Survey – win a new iPad
Redgate’s 2020 State of Database DevOps Survey is open now. Share your views on Database DevOps today for a chance to win a new 65GB iPad Air. Plus, for every entry, Redgate will donate $1 to UNICEF. Take the survey now.
2019-12-18 (first published: 2019-11-12)
Test data provisioning for development – free whitepaper
Compare the most common approaches to provisioning test data to database development teams and see how they stack up.
Learn why traditional approaches like restore from backup are no longer suitable, and how successful organizations are implementing a combined data masking and data virtualization approach.
2019-12-17
Update only Year, Month or Day in a SQL Server Date
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers