cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
641

Fundamentals: DBCC - SQL Server's FDISK

SQL-Server-Team on Mar 23 2019 12:11 PM
First published on TECHNET on May 20, 2011 [Prior Post In Series] [Backup Series] [Next Post in Series]In a time long lo...
468

Backups: Doing it right so you can recover quickly!– Automating the backups

SQL-Server-Team on Mar 23 2019 12:11 PM
First published on TECHNET on May 13, 2011 [Prior Post] [Next Post]Getting backups scheduled appropriately tends to be a...
407

Backups: Doing it right so you can recover quickly!– Don’t keep your eggs in one basket

SQL-Server-Team on Mar 23 2019 12:10 PM
First published on TECHNET on May 06, 2011 [Prior Post] [Next Post]In my prior post I looked at confirming that backups ...
418

Backups: Doing it right so you can recover quickly! - Checking backups have occurred.

SQL-Server-Team on Mar 23 2019 12:09 PM
First published on TECHNET on Apr 26, 2011 [Next Post]Over the last few months I have been reviewing presentations at us...
9,884

Fundamentals: Cloning a production database to a test server

SQL-Server-Team on Mar 23 2019 12:08 PM
First published on TECHNET on Apr 22, 2011 Recently I had a conversation with someone who maintains an ISV offering.
1,846

Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

SQL-Server-Team on Mar 23 2019 12:04 PM
First published on TECHNET on Apr 15, 2011 [Prior Post in Series] [Next Post in Series]In my prior posts, I looked at ad...
1,394

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

SQL-Server-Team on Mar 23 2019 12:04 PM
First published on TECHNET on Apr 08, 2011 [Prior Post in Series] [Next Post in Series]In my last post Fundamentals: Cre...
440

Tuning ISV SQL Server databases - Overview

SQL-Server-Team on Mar 23 2019 12:01 PM
First published on TECHNET on Apr 07, 2011 [Next Post in Series - SmarTeam Tuning]In the following months, I hope to do ...
2,386

Adding enhanced password constraints to SQL Server

SQL-Server-Team on Mar 23 2019 12:00 PM
First published on TECHNET on Mar 29, 2011 [Prior Post in Series] [Next Post in Series]In my prior posts on applying PCI...
639

Best Practices Analyzer for ISV SQL Servers to protect your company’s property

SQL-Server-Team on Mar 23 2019 11:58 AM
First published on TECHNET on Mar 07, 2011 The intellectual property(IP) or other valuable information may be stored on ...
498

Migrating from Oracle to SQL Server

SQL-Server-Team on Mar 23 2019 11:55 AM
First published on TECHNET on Mar 04, 2011 [Next Post in Series: Kronos Migration]My first experience with data migratio...
476

Don’t let documents and mixed media complicate your product!

SQL-Server-Team on Mar 23 2019 11:55 AM
First published on TECHNET on Mar 04, 2011 For the last twenty-five years, I have faced the pain of needing to store doc...
521

Improving SQL Server Security to PCIDSS Standards

SQL-Server-Team on Mar 23 2019 11:55 AM
First published on TECHNET on Mar 02, 2011 Author: This article is written by our contributing author Ken Lassesen.
490

Right sizing ISV installations for the best bang for the buck!

SQL-Server-Team on Mar 23 2019 11:54 AM
First published on TECHNET on Feb 28, 2011 Author: This article is written by our contributing author Ken Lassesen.
377

How Important Is Your Data? (Mini-Lab Part 2/2)

SQL-Server-Team on Mar 23 2019 11:51 AM
First published on TECHNET on Jan 26, 2011 [Prior Post in Series]In Part 1 of this 2 part Mini-Lab series we looked at s...
462

How Important Is Your Data? (Mini-Lab Part 1/2)

SQL-Server-Team on Mar 23 2019 11:51 AM
First published on TECHNET on Jan 24, 2011 [Next Post in Series]What would it mean to you and your business if a hacker ...
801

Benchmarking Series "The Benchmarking Process" (5/5)

SQL-Server-Team on Mar 23 2019 11:49 AM
First published on TECHNET on Jan 18, 2011 [Prior Post in Series]In this 5 part Benchmarking Series we have discussed:Th...
633

Benchmarking Series "Benchmark Sizing Guide" (4/5)

SQL-Server-Team on Mar 23 2019 11:49 AM
First published on TECHNET on Jan 13, 2011 [Prior Post in Series] [Next Post in Series]A sizing guide will help you budg...
384

Benchmarking Series "The Applicability/Usage of a Benchmark" (3/5)

SQL-Server-Team on Mar 23 2019 11:48 AM
First published on TECHNET on Jan 11, 2011 [Prior Post in Series] [Next Post in Series]In Part 2 of the Benchmarking Ser...
418

Benchmarking Series "The Elements of a Benchmark" (2/5)

SQL-Server-Team on Mar 23 2019 11:48 AM
First published on TECHNET on Jan 06, 2011 [Prior Post in Series] [Next Post in Series] In Part 1 of the Benchmarking Se...
399

Benchmarking Series "The Need For Benchmarking" (1/5)

SQL-Server-Team on Mar 23 2019 11:48 AM
First published on TECHNET on Jan 04, 2011 [Prior Post in Series] [Next Post in Series]Benchmarks can best be described ...
391

Benchmarking Series "Introduction" (0/5)

SQL-Server-Team on Mar 23 2019 11:47 AM
First published on TECHNET on Dec 30, 2010 [Next Post in Series]Starting next week we will be doing a 5 part blog series...
391

Use CPU Instance Counters for Better Insight

SQL-Server-Team on Mar 23 2019 11:47 AM
First published on TECHNET on Dec 28, 2010 Windows Performance Monitor, a management tool included with Windows, is a ke...
1,515

Using Read-Committed Snapshot Isolation - Mini-Lab

SQL-Server-Team on Mar 23 2019 11:46 AM
First published on TECHNET on Dec 21, 2010 Dassault ENOVIA requires the use of read-committed snapshot isolation.
444

Mini-Lab - Part 2 - Backup Compression with Resource Governor

SQL-Server-Team on Mar 23 2019 11:46 AM
First published on TECHNET on Dec 15, 2010 [Prior Post in Series]In Part 1 of this 2 part Mini-Lab series we looked at a...
452

Mini-Lab - Part 1 - Backup Compression

SQL-Server-Team on Mar 23 2019 11:46 AM
First published on TECHNET on Dec 14, 2010 [Next Post in Series]In previous blog posts we have touched briefly on some o...
465

PROS: Oracle to SQL Case Study

SQL-Server-Team on Mar 23 2019 11:43 AM
First published on TECHNET on Dec 03, 2010 Companies must address complex pricing issues, involving increasingly sophist...
2,188

Change Data Capture - What is it and how do I use it?

SQL-Server-Team on Mar 23 2019 11:43 AM
First published on TECHNET on Dec 02, 2010 In the All Good Things Come to an End - Why You Should Upgrade article we dis...
452

All Good Things Come to an End - Why You Should Upgrade

SQL-Server-Team on Mar 23 2019 11:43 AM
First published on TECHNET on Dec 01, 2010 With Microsoft announcing the release of the Community Technology Preview 1 (...
2,195

Temenos T24 - Trace Flag 834 and When to Use It

SQL-Server-Team on Mar 23 2019 11:42 AM
First published on TECHNET on Nov 30, 2010 TEMENOS T24 (T24) is a complete banking solution designed to meet the challen...

Latest Comments

mbourgon_optum
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 23 2024 07:24 AM
Yeah, double+ agree on the whole "without AG awareness, both are pretty useless". Sounds amazing, but practically I can't use it. Dammit.
0 Likes
skusen
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 22 2024 08:27 AM
@SivertSolem I built out a bunch of automation around this using functions from dbatools. As far as automatic like this, I don't know of anything that exists.
1 Likes
AnabilSaha
in SQL Server Licensing: High Availability and Disaster Recovery benefits on Apr 20 2024 11:36 AM
Hello Mr Banerjee. It's a really very helpful video. I have a real time scenario can you please suggest me what is your view on that ?In my current production server an architecture was decided that is going to have 2 vms for db server where 1 will be primary and 2nd will be secondary. But suddenly ...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 11:54 AM
@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 07:13 AM
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes