SQL Data Discovery and Classification

One of the best features that added to SSMS this year is Data Discovery and Classification. This is supported for SQL Server 2008 and higher versions. Just right click on the database and choose the classify data under task category.

This tool quickly categorizes personal data within a database, discovering and classifying the most sensitive data which is usually is the first step for the GDPR compliance strategy.

You can find more information here.

Advertisements

T-SQL: How to Sort a Column that Contains Character-Separated Numbers 

we can use the sorting based on hierarchyid data type which in each node is based on numeric sort order.

SELECT *
FROM dbo.Letters
ORDER BY
CAST(N'/' + IndicatorCode + N'/' AS HIERARCHYID)

 

 

Source: T-SQL: How to Sort a Column that Contains Character-Separated Numbers – TechNet Articles – United States (English) – TechNet Wiki

Adaptive query processing in SQL Server 2017

The batch mode adaptive joins feature enables the choice of a hash join or nested loop join method to be deferred until after the first input has been scanned. The adaptive join operator defines a threshold that is used to decide when to switch to a nested loop plan. Your plan can therefore dynamically switch to a better join strategy during execution. Here’s how it works:

If the row count of the build join input is small enough that a nested loop join would be more optimal than a hash join, your plan switches to a nested loop algorithm.

If the build join input exceeds a specific row count threshold, no switch occurs and your plan continues with a hash join.

Source: Adaptive query processing in Microsoft SQL databases | Microsoft Docs

Model many-to-many relationships using SQL Server Graph Database

A graph database is a collection of nodes (or vertices) and edges (or relationships). A node represents an entity (for example, a person or an organization) and an edge represents a relationship between the two nodes that it connects (for example, likes or friends). Both nodes and edges may have properties associated with them.

Source: SQL Graph overview | Microsoft Docs

Using the FORCESEEK Table Hint

If a plan contains table or index scan operators, and the corresponding tables cause a high number of reads during the execution of the query, as observed in the STATISTICS IO output, forcing an index seek operation may yield better query performance. This is especially true when inaccurate cardinality or cost estimations cause the optimizer to favor scan operations at plan compilation time.

Source: Using the FORCESEEK Table Hint

TNWikiSummit15 Presentation: Error Handling in SQL Server 2012 and 2014

 

The follow text is copied from this blog:
Official Blog of TechNet Wiki

 

Using Error Handling within the Transact SQL language needs a deep knowledge. It depends on the SQL Server version, there are various implementations for handling the errors in T-SQL. But if you use SQL Server 2012 or later versions, you can use the simplest and fully structured error handling.

Saeid Hasani showed how to implement such simple error handling in T-SQL. He showed this topic from a problem solving approach and particularly in SQL Server 2012  and the later versions. In this session, he covered some questions to providing a step by step tutorial for designing a structured error handling mechanism in SQL Server.

This session is available for download using the following links:

Video:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-dfdcb9a5

PowerPoint:

https://gallery.technet.microsoft.com/TN-Summit15-Structured-118896bb

Original TN Wiki Article:

http://social.technet.microsoft.com/wiki/contents/articles/20002.structured-error-handling-mechanism-in-sql-server-2012.aspx

Judges’ comments for the article are from TechNet GURU Awards – September 2013 :

Richard Mueller:

“Useful tutorial with lots of examples and very good links. Excellent comparison of THROW and RAISERROR.”

Jinchun Chen:

“Nice article. Thank you for the sharing.”

Ed Price:

“Incredibly well formatted with images, code, and explanations. And great interactions in the comments, making the improvements suggested by Naomi. ”

DB:

“Useful, clear and accurate guidance on error handling”

Samuel Lester:

“Great coverage of different techniques, challenges, pros/cons. Well done, very informative, and easy to read.”

 

TechNet Wiki International Summit 2015

You can register by filling out the TNWiki Summit15 form  and choosing your favorite Presentations.

Registration for TNWiki Summit15 are open  REGISTER NOW   !!!

Here’s the schedule:

 DAY 1 – March, 17th
Time / GMT  DEV track WIKI track  INFRA track
GMT “-8”  :  01h00PM
GMT “-2”  :  07h00PM
GMT “0”   :  09h00PM
GMT “+2” :  11h00PM
“TechNet Wiki
Social Synergy”
by Ed Price
GMT “-8”  :  01h45PM
GMT “-2”  :  07h45PM
GMT “0”   :  09h45PM
GMT “+2” :  11h45PM
“SharePoint:
Adding client-side
controls to an AngularJS
app in Office 365”
by Matthew Yarlett
“Wiki Life (Turkish):
Best Practices”
by Hasan Dimdik,
Erdem SELÇUK,
Recep YUKSEL
and Ugur Demir
“SQL Server:
SQL Server Memory”
by Shashank Singh
aka Shanky
GMT “-8”  :  02h30PM
GMT “-2”  :  08h30PM
GMT “0”   :  10h30PM
GMT “+2” :  12h30AM
“Wiki Life (Portuguese):
Best Practices”
by Alan Carlos,
Durval Ramos
and Luciano Lima
“Exchange Server
Kurulum SenaryolariKSEL”
by Recep YUKSEL
(only Turkish Language)
GMT “-8”  :  03h15PM
GMT “-2”  :  09h15PM
GMT “0”   :  11h15PM
GMT “+2” :  01h15AM
“Small Basic”
by Ed Price
“Writing a Good Wiki Article”
by Matthew Yarlett
“Segurança em Profundidade
em Ambientes Microsoft”
by Luciano Lima
(only Portuguese Language)
 DAY 2 – March, 18th
Time / GMT  DEV track WIKI track  INFRA track
GMT “-8”  :  09h00AM
GMT “-2”  :  03h00PM
GMT “0”   :  05h00PM
GMT “+2” :  07h00PM
“Creating and Querying
Microsoft Azure
DocumentDB”
by Chervine Bhiwoo
“Visio with Office 365
SharePoint Online”
by Daniel Christian
aka Dan Christian
GMT “-8”  :  09h45AM
GMT “-2”  :  03h45PM
GMT “0”   :  05h45PM
GMT “+2” :  07h45PM
“Visual C#:
Working with
WCF Data Services”
by Jaliya Udagedara
“Cross-Linking and Making
our Articles Discoverable”
by Richard Mueller
“Transact-SQL:
The power of
INSTEAD OF Triggers”
by Ronen Ariely aka Pituach
GMT “-8”  :  10h30AM
GMT “-2”  :  04h30PM
GMT “0”   :  06h30PM
GMT “+2” :  08h30PM
“Building a Business
Intelligence Solution with
Power BI Components”
by Paul Turley
“Wiki Ninjas
Social Media”
by Ronen Ariely aka Pituach,
Peter Geelen
and Sandro Pereira
“Windows Server:
Leading Spaces in
Active Directory Names”
by Richard Mueller
GMT “-8”  :  11h15AM
GMT “-2”  :  05h15PM
GMT “0”   :  07h15PM
GMT “+2” :  09h15PM
“Small Basic and TechNet”
by Nonki Takahashi
“Exchange Server”
by Ugur Demir
(only Turkish Language)
GMT “-8”  :  01h45PM
GMT “-2”  :  07h45PM
GMT “0”   :  09h45PM
GMT “+2” :  11h45PM
“How to Integrate Cortana
in a Windows Phone
application”
by Sara M.G.Silva
“TechNet Guru”
by Peter Laker
aka XAML guy
“BizTalk Server 2013 R2
JSON support and
integration with Cloud API’s”
by Steef-Jan Wiggers
GMT “-8”  :  02h30PM
GMT “-2”  :  08h30PM
GMT “0”   :  10h30PM
GMT “+2” :  12h30AM
“Wiki Ninja Belts”
by Margriet Bruggeman,
Peter Laker
aka XAML guy
and Ed Price
“DevOps Desenvolvimento
e Operações Juntos!”
by Alan Carlos
(only Portuguese Language)
 DAY 3 – March, 19th
Time / GMT  DEV track WIKI track  INFRA track
GMT “-8”  :  11h15AM
GMT “-2”  :  05h15PM
GMT “0”   :  07h15PM
GMT “+2” :  09h15PM
“Implementing audio
media stream sources in
windows phone 8.1”
by Mihai Cosmin
aka MCosmin
GMT “-8”  :  12h00PM
GMT “-2”  :  06h00PM
GMT “0”   :  08h00PM
GMT “+2” :  10h00PM
“Office 365
SharePoint Uygulamalari”
by Erdem SELÇUK
(only Turkish Language)
“Présentation de la recherche
dans SharePoint 2013”
by Benoit Jester
(only French Language)
GMT “-8”  :  01h00PM
GMT “-2”  :  07h00PM
GMT “0”   :  09h00PM
GMT “+2” :  11h00PM
“Wiki Life (French):
Best Practices”
by Benoit Jester
and Gokan Ozcifci
“Windows Server:
Active Directory Migration”
by Hasan Dimdik
GMT “-8”  :  01h45PM
GMT “-2”  :  07h45PM
GMT “0”   :  09h45PM
GMT “+2” :  11h45PM
“Structured Error
Handling Mechanism
in SQL Server 2012 & 2014”
by Saeid Hasani
“Wiki Life: Technet Wiki
Best Practices
(from administrators view)”
by Peter Geelen
“The good,the bad and ugly
part for Office365
for large sized enterprises”
by Gokan Ozcifci
(only French Language)
GMT “-8”  :  02h30PM
GMT “-2”  :  08h30PM
GMT “0”   :  10h30PM
GMT “+2” :  12h30AM
“Getting Started with
MongoDB on Azure”
by Jan Hentschel
aka Horizon_Net
“TechNet Wiki:
User Groups”
by Craig Lussier
GMT “-8”  :  03h15PM
GMT “-2”  :  09h15PM
GMT “0”   :  11h15PM
GMT “+2” :  01h15AM
“From Forums to Wiki:
Templates”
by Sandro Pereira
“FIM 2010
Best Practices & Technet Wiki”
by Peter Geelen
GMT “-8”  :  04h00PM
GMT “-2”  :  10h00PM
GMT “0”   :  12h00AM
GMT “+2” :  02h00AM
“Evitando que minha
coluna IDENTITY quebre
a sequencia numérica”
by Durval Ramos
(only Portuguese Language)
“TechNet Wiki
International Communities”
by Ed Price
“The difference between
SharePoint On-Prem’ platforms
and Cloud/Hybrid”
by Gokan Ozcifci

 

Webinar: Error Handling in SQL Server

 

TN Summit 2015

 

March 19, 2015 9:45 PM GMT

Saeid Hasani

Structured Error Handling in SQL Server

The goal of this session is to provide a simple and easy to use error handling mechanism with minimum complexity. This session is compatible with MS SQL SERVER 2012 and 2014.

Biography

Saeid Hasani is a Senior Database Developer, SQL Server Consultant, freelance SQL author and T-SQL Trainer. His main expertise is T-SQL Programming and Query Tuning. As a database developer, he has several years of experience in developing software in various domains such as MIS, ERP and customized Enterprise applications. As a freelance SQL author, he has been writing about SQL since 2010. He has been one of the MSDN SQL Server Forums Moderators.

Webinar Link: https://www307.livemeeting.com/lrs/0000000379_116/Registration.aspx?pageName=gdx8jdv0r7rmftrk