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
4,874

Azure Data Studio 1.48 is now available

DavidLevy on Feb 28 2024 02:49 PM
Learn about the latest features and improvements in Azure Data Studio
2,386

Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database

uc-msft on May 25 2023 09:14 AM
Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database
3,872

Announcing GA of adutil-A tool to ease configuration of AD authentication for SQL on Linux/Container

amvin87 on Oct 01 2021 09:18 AM
Announcing General Availability of adutil - A tool to ease the process of configuring AD authentication for SQL On Linux...
1,571

Logging Schema-changes in a Database using DDL Trigger

AndreasWolter on Dec 02 2020 12:30 PM
How to use DDL Triggers to record Database-changes in a table.
770

Interesting issue with Filtered indexes.

SQL-Server-Team on Mar 23 2019 11:17 AM
First published on MSDN on Jun 29, 2009 Recently, an ISV I work with ran into an interesting problem with Filtered Index...
2,609

Why did the size of my indexes expand when I rebuilt my indexes?

SQL-Server-Team on Mar 23 2019 11:16 AM
First published on MSDN on May 18, 2009 Recently I worked with a partner who was seeing some interesting behavior.
635

SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.

SQL-Server-Team on Mar 23 2019 11:15 AM
First published on MSDN on Apr 10, 2009 An ISV recently found an anomoly in their implementation of a "drop table partit...
367

Avoid using JDK Date APIs to handle timezone sensitive date and time

SQL-Server-Team on Mar 23 2019 11:15 AM
First published on MSDN on Mar 26, 2009 JDK APIs for Class “java.
735

Zeroing in on blocking on seemingly unrelated tables

SQL-Server-Team on Mar 23 2019 11:12 AM
First published on MSDN on Feb 02, 2009 In one of our recent lab tests we were surprised to see blocking occur on a tabl...
634

Using SQL Server 2008 Management Data Warehouse for database monitoring in my application

SQL-Server-Team on Mar 23 2019 11:11 AM
First published on MSDN on Jan 29, 2009 SQL Server 2008 introduced what we call the Management Data Warehouse.
6,507

OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 feature

SQL-Server-Team on Mar 23 2019 11:06 AM
First published on MSDN on Nov 26, 2008 Using parameterized queries is a well known SQL Server Best Practice.
3,974

SQL Server 2008 : new binary – hex string conversion functionality can dramatically improve related query performance by orders of magnitude.

SQL-Server-Team on Mar 23 2019 11:05 AM
First published on MSDN on Oct 31, 2008 In previous SQL Server releases it wasn’t possible to convert binary data to str...
9,628

How to create an autonomous transaction in SQL Server 2008

SQL-Server-Team on Mar 23 2019 11:01 AM
First published on MSDN on Aug 22, 2008 I have been asked by many customers and partners, especially those migrating fro...
15.6K

UPDATE with OUTPUT clause – Triggers – and SQLMoreResults

SQL-Server-Team on Mar 23 2019 10:58 AM
First published on MSDN on Jul 11, 2008 NOTE: the code in this BLOG is TSQL instead of ODBC calls.
646

Use SQL Server replay tools to reproduce and resolve customer issues

SQL-Server-Team on Mar 23 2019 05:23 AM
First published on MSDN on Jun 26, 2008 For many ISVs run that into issues at customer sites, it is sometimes difficult ...
3,694

SQL Server Intermittent Connectivity Issue

SQL-Server-Team on Mar 23 2019 05:22 AM
First published on MSDN on May 27, 2008 Recently many customers of an ISV I work with, reported intermittent connectivit...
2,625

Using time zone data in SQL Server 2008

SQL-Server-Team on Mar 23 2019 05:16 AM
First published on MSDN on Mar 18, 2008 In SQL Server 2008 Microsoft has introduced a number of new date and time data t...
9,495

Increase your SQL Server performance by replacing cursors with set operations

SQL-Server-Team on Mar 23 2019 05:15 AM
First published on MSDN on Mar 18, 2008 You have probably heard many times, from different sources, that as a best pract...
325

Appending Data Using SQL 2008 Filestream

SQL-Server-Team on Mar 23 2019 05:15 AM
First published on MSDN on Mar 06, 2008 SQL Server 2008 has a new feature called Filestream, which allows you to save la...
2,138

Detecting Overlapping Indexes in SQL Server 2005

SQL-Server-Team on Mar 23 2019 05:04 AM
First published on MSDN on Jun 29, 2007 When SQL Server has an optimal index that satisfies the search predicates of a q...
468

New SQL Best Practice Articles now available

SQL-Server-Team on Mar 23 2019 05:02 AM
First published on MSDN on Jun 05, 2007 Please have a look at four new Best Practices Articles SQL Server 2005 Predeploy...
454

why cannot i GRANT EXECUTE permission on assemblies anymore ?

SQL-Server-Team on Mar 23 2019 04:51 AM
First published on MSDN on Feb 22, 2007 Just a quick note that this is by design and no you don't need to use it.
1,718

4.0 Useful Queries on DMV’s to understand Plan Cache Behavior

sshekar on Mar 23 2019 04:50 AM
First published on MSDN on Jan 23, 2007
1,143

2.0 Diagnosing Plan Cache Related Performance Problems and Suggested Solutions

sshekar on Mar 23 2019 04:50 AM
First published on MSDN on Jan 21, 2007
688

12.0 Plan Cache Trace Events and Performance Counters

sshekar on Mar 23 2019 04:49 AM
First published on MSDN on Jan 19, 2007
1,718

11.0 Temporary Tables, Table Variables and Recompiles

sshekar on Mar 23 2019 04:49 AM
First published on MSDN on Jan 18, 2007
363

10.0 Plan Cache Flush

sshekar on Mar 23 2019 04:48 AM
First published on MSDN on Jan 17, 2007
569

9.0 Memory Pressure Limits

sshekar on Mar 23 2019 04:48 AM
First published on MSDN on Jan 16, 2007
319

8.0 Factors that Affect Batch Cache-ability

sshekar on Mar 23 2019 04:48 AM
First published on MSDN on Jan 15, 2007
269

7.0 Costing Cache Entries

sshekar on Mar 23 2019 04:47 AM
First published on MSDN on Jan 14, 2007

Latest Comments

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
sgtmango333
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 06:48 AM
I understand the intent, but that makes life a difficult for those using a Central Management Server with hundreds of instances. That means that every one on my team must now connnect to every server and update this setting just to maintain functionality after installing version 20. So next question...
0 Likes
SivertSolem
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 17 2024 04:16 AM
@TarynPratt wrote:At this point, patching SQL Server on Azure VMs through Azure Update Manager or Automated Patching via the SQL IaaS extension is not aware if the SQL Server is a part of an Always On availability group. It is important to keep this in mind when scheduling your updates with an autom...
1 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 16 2024 06:15 PM
@sgtmango333 I missed your question, apologies. It is not possible to set the default value for the Encryption property to optional. With SSMS 20 we upgraded to MDS 5.x, which sets Encryption to Mandatory (true) by default. We intentionally decided to stay with the default, to encourage folks toward...
1 Likes