SQL Server

More Topics
Modifying the Default SQL Script in Management Studio
SQL Server
Modifying the Default SQL Script in Management StudioModifying the Default SQL Script in Management Studio

One simple solution you can employ to avoid running a query against the wrong instance, is altering the code that populates each and every New Query window that is populated in SSMS, the default query.

byTim Ford
Jul 21, 2014
|
1 Min Read
SQL
SQL Server
Connecting to SQL Server via SSMSConnecting to SQL Server via SSMS
byJohn Savill
Jul 19, 2014
1 Min Read
SQL Server query results
SQL Server
Identifying Query Text and Graphical Execution Plans in Active QueriesIdentifying Query Text and Graphical Execution Plans in Active Queries
byTim Ford
Jul 16, 2014
1 Min Read
Baby duck swimming alone
SQL Server
The Marginalization of SQL Server Standard EditionThe Marginalization of SQL Server Standard Edition
byITPro Today
Jul 15, 2014
1 Min Read
azure blue windows with clouds
Innovations of the 2010s (SQL Server 2012 – 2019)
SQL License Requirements in Windows AzureSQL License Requirements in Windows Azure
byJohn Savill
Jul 14, 2014
1 Min Read
sequence
SQL Server
Identifying a Subsequence in a Sequence, Part 3Identifying a Subsequence in a Sequence, Part 3
byItzik Ben-Gan
Jul 14, 2014
1 Min Read
ASP.NET Session State Provider for SQL Server 2014 In-Memory OLTP
Innovations of the 2010s (SQL Server 2012 – 2019)
ASP.NET Session State Provider for SQL Server 2014 In-Memory OLTP
ASP.NET Session State Provider for SQL Server 2014 In-Memory OLTP
Jul 12, 2014
|
8 Slides
byJayleen Heft
Configuring AlwaysOn Read-Only Replicas
SQL Server
Configuring AlwaysOn Read-Only Replicas
Configuring AlwaysOn Read-Only Replicas
Jul 11, 2014
|
1 Min Read
byMichael Otey
Microsoft Releases SQL Server 2012 SP2 ISO without SP2, Fix Imminent
Innovations of the 2010s (SQL Server 2012 – 2019)
Microsoft Releases SQL Server 2012 SP2 ISO without SP2, Fix Imminent
Microsoft Releases SQL Server 2012 SP2 ISO without SP2, Fix Imminent
Jul 11, 2014
|
1 Min Read
byRod Trent
Essential SQL Server Monitoring: Top Issues Identified by Health Checks
SQL Server
Essential SQL Server Monitoring: Top Issues Identified by Health Checks
Essential SQL Server Monitoring: Top Issues Identified by Health Checks
Jul 10, 2014
|
1 Min Read
byITPro Today
sql server 2008 and sql sever 2008 R2 Support Table
Early Versions (SQL Server 2000 – 2008)
Mainstream Support Ends for SQL Server 2008, 2008 R2
Mainstream Support Ends for SQL Server 2008, 2008 R2
Jul 9, 2014
|
1 Min Read
byJayleen Heft
Mountain trail through Rocky Mountain National Park
SQL Server
Using the all_columns System View in SQL Server
Using the all_columns System View in SQL Server
Jul 9, 2014
|
1 Min Read
byTim Ford
SQL Server 2012 SP2 Now Supported for SCCM 2012 SP1 and R2
Innovations of the 2010s (SQL Server 2012 – 2019)
SQL Server 2012 SP2 Now Supported for SCCM 2012 SP1 and R2
SQL Server 2012 SP2 Now Supported for SCCM 2012 SP1 and R2
Jul 8, 2014
|
1 Min Read
byRod Trent
graph
SQL Server
8 Free Business Intelligence Tools
8 Free Business Intelligence Tools
Jun 26, 2014
|
8 Slides
byJayleen Heft
dbForge Studiow for SQL Server version 38
Innovations of the 2010s (SQL Server 2012 – 2019)
New Product: dbForge Studio for SQL Server v3.8
New Product: dbForge Studio for SQL Server v3.8
Jun 21, 2014
|
1 Min Read
byJayleen Heft
Piano keys
SQL Server
Foreign Key Constraints: Friend or Frenemy?
Foreign Key Constraints: Friend or Frenemy?
Jun 20, 2014
|
1 Min Read
byMickey Stuewe
SQL Server 2012 SP2 Released
Innovations of the 2010s (SQL Server 2012 – 2019)
SQL Server 2012 SP2 Released
SQL Server 2012 SP2 Released
Jun 13, 2014
|
1 Min Read
byJayleen Heft
Eron Kelly explaining improvements made to SQL Server 2014
Innovations of the 2010s (SQL Server 2012 – 2019)
Microsoft’s Eron Kelly on Power BI, SQL Server 2014 Performance Improvements
Microsoft’s Eron Kelly on Power BI, SQL Server 2014 Performance Improvements
Jun 12, 2014
|
1 Min Read
byBlair Greenwood
Disturbing Problems with SQL Server 2014
Innovations of the 2010s (SQL Server 2012 – 2019)
Disturbing Problems with SQL Server 2014
Disturbing Problems with SQL Server 2014
Jun 12, 2014
|
1 Min Read
byMichael K. Campbell
egg carton with missing brown egg
SQL Server
Missing Indexes Correlated Against Execution Costs and Counts
Missing Indexes Correlated Against Execution Costs and Counts
Jun 11, 2014
|
1 Min Read
byITPro Today
Microsoft SQL Server 2012 SP2 Available Today
Innovations of the 2010s (SQL Server 2012 – 2019)
Microsoft SQL Server 2012 SP2 Available Today
Microsoft SQL Server 2012 SP2 Available Today
Jun 10, 2014
|
1 Min Read
byRod Trent
IT/Dev Connections—SQL Server Full-Day Workshops
SQL Server
IT/Dev Connections—SQL Server Full-Day Workshops
IT/Dev Connections—SQL Server Full-Day Workshops
Jun 10, 2014
|
6 Slides
byKelsey Levitt
SQL spelled out on keyboard
SQL Server
Optimization Tips for Multiple Range Predicates, Part 2
Optimization Tips for Multiple Range Predicates, Part 2
Jun 10, 2014
|
1 Min Read
byItzik Ben-Gan
Two young men on grass with SQL Server books flying in the air
Early Versions (SQL Server 2000 – 2008)
Top 10 Highly Recommended SQL Server Books
Top 10 Highly Recommended SQL Server Books
May 30, 2014
|
10 Slides
byJayleen Heft
SQL Server 2008 and 2008 R2 to Get One Last Service Pack
Early Versions (SQL Server 2000 – 2008)
SQL Server 2008 and 2008 R2 to Get One Last Service Pack
SQL Server 2008 and 2008 R2 to Get One Last Service Pack
May 29, 2014
|
1 Min Read
byRod Trent
The modern IT workforce
SQL Server
Increasing the SSMS Table Designer Timeout Value
Increasing the SSMS Table Designer Timeout Value
May 28, 2014
|
1 Min Read
byMichael Otey
Microsoft sign on building
Innovations of the 2010s (SQL Server 2012 – 2019)
10 Must Read SQL Server FAQs
10 Must Read SQL Server FAQs
May 24, 2014
|
10 Slides
byJayleen Heft
Time to start sign with clock and clouds in background
SQL Server
SQL Server DBA Tip: One Time Schedules
SQL Server DBA Tip: One Time Schedules
May 20, 2014
|
1 Min Read
byITPro Today
Sizing In-Memory OLTP Hash Indexes
Innovations of the 2010s (SQL Server 2012 – 2019)
Sizing In-Memory OLTP Hash Indexes
Sizing In-Memory OLTP Hash Indexes
May 19, 2014
|
1 Min Read
byMichael Otey
SQL database code
SQL Server
Optimization Tips for Multiple Range Predicates, Part 1
Optimization Tips for Multiple Range Predicates, Part 1
May 15, 2014
|
1 Min Read
byItzik Ben-Gan
TechEd 2014 Best of TechEd booth
Innovations of the 2010s (SQL Server 2012 – 2019)
Scenes from Microsoft TechEd 2014 in Houston
Scenes from Microsoft TechEd 2014 in Houston
May 14, 2014
|
6 Slides
byJayleen Heft
Microsoft logo on the side of a building
SQL Server
SQL Server DBA Tip: Credentials and Proxies
SQL Server DBA Tip: Credentials and Proxies
May 13, 2014
|
1 Min Read
byITPro Today
Executive Summary: Deploying Affordable, High Performance Hybrid Storage for Clustered SQL Server
SQL Server
Executive Summary: Deploying Affordable, High Performance Hybrid Storage for Clustered SQL Server
Executive Summary: Deploying Affordable, High Performance Hybrid Storage for Clustered SQL Server
May 8, 2014
|
1 Min Read
byITPro Today
Microsoft TechEd 2014: Melissa Data's New De-Duplication Functionality in MatchUp for SSIS
Innovations of the 2010s (SQL Server 2012 – 2019)
Microsoft TechEd 2014: Melissa Data's New De-Duplication Functionality in MatchUp for SSIS
Microsoft TechEd 2014: Melissa Data's New De-Duplication Functionality in MatchUp for SSIS
May 8, 2014
|
1 Min Read
byBlair Greenwood
SQL Server Roundup: All You Need to Know for Microsoft TechEd 2014
Innovations of the 2010s (SQL Server 2012 – 2019)
SQL Server Roundup: All You Need to Know for Microsoft TechEd 2014
SQL Server Roundup: All You Need to Know for Microsoft TechEd 2014
May 7, 2014
|
1 Min Read
byBlair Greenwood

Editor's Choice

the interface of the PowerShell search tool with a hand holding a magnifying glass on a background of a blue sky and clouds in the shape of gears
PowerShell
How I Built My Own PowerShell Multi-File Search Tool
How I Built My Own PowerShell Multi-File Search Tool

Oct 22, 2024

burnout gif featuring a mannequin surrounded by office technology on fire
Career Tips
Am I Burned Out? How To Identify and Address Burnout in IT
Am I Burned Out? How To Identify and Address Burnout in IT

Oct 24, 2024

MLOps
Ops and More
Choosing Between Cloud and On-Prem MLOps: What's Best for Your Needs?
Choosing Between Cloud and On-Prem MLOps: What's Best for Your Needs?

Oct 23, 2024

Exclusive ITPro Resources
See all ITPro Resources

Featured Technical Explainers

AI chip
Cloud Computing
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
SaaS concept on a tablet
Cloud Computing
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
DevOps logo on top of code
DevOps
DevOps: Key to Faster, More Efficient Government Software Development
DevOps: Key to Faster, More Efficient Government Software Development
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up

Recent What Is

cartoon shows a person next to a checklist and several icons that represent disaster scenarios
Disaster Recovery
BCDR Basics: A Quick Reference Guide for Business Continuity & Disaster RecoveryBCDR Basics: A Quick Reference Guide for IT Pros
technology interface with a person's hand drawing gears and cogs
PowerShell
Introduction To PowerShell Environment VariablesIntroduction To PowerShell Environment Variables
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Newsletter Sign-Up