Sites anglophones


Adventures In Foreign Keys 1: Eligibility Is Everything

Publié le 12 novembre 2018 sur brentozar.com
 

In A Foreign Key, In A Foreign Table Much of what people want from foreign keys, like referential integrity and join elimination, are only as guaranteed as much as SQL Server can trust your constraints (and even then…). The same goes for check c …

Testing PowerShell Modules with Pester

Publié le 12 novembre 2018 sur sqlservercentral.com
 

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.

Linear barcodes in SSRS using the Barcode Image Generation Library

Publié le 12 novembre 2018 sur sqlservercentral.com
 

The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.

Getting executive buy in for DevOps – 3 top tips Webinar

Publié le 12 novembre 2018 sur sqlservercentral.com
 

In this webinar, Microsoft MVP Kendra Little will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. She will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that …

SQL SERVER – Initializing the FallBack Certificate Failed With Error Code: 1, State: 20, Error Number: 0

Publié le 12 novembre 2018 sur journey to sqlauthority
 

One of my clients came with an issue with SQL Server startup. As per them, they just changed the password of SQL Server Service account using the configuration manager. In this blog we would learn about how to fix Initializing the FallBack certificate …

[Video] Office Hours 2018/11/7 (With Transcriptions)

Publié le 11 novembre 2018 sur brentozar.com
 

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database backups, monitoring products, parameterization, page latch waits, SQL ConstantCare, and Availability Groups on 2017 Standard Edition. Here’s the video …

Does Sort Order in Index Column Matters for Performance? – Interview Question of the Week #199

Publié le 11 novembre 2018 sur journey to sqlauthority
 

Question: Does Sort Order in Index Column Matters for Performance? Answer: Wow, it has been a long time since I have heard this question and the matter of fact, I have never blogged about this subject on this blog. I have received this question du …

SQL SERVER – How to Escape a Single Quote in SQL Server?

Publié le 10 novembre 2018 sur journey to sqlauthority
 

In my earlier post on “How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192 I showed you a method of escaping a single quote. In this post, I will show you another method to produce the same result Let us consid …

2019 State of Database DevOps – Take the survey!

Publié le 9 novembre 2018 sur sqlservercentral.com
 

Database development practices are more integral than ever to DevOps success. How are we saving time, automating processes, deploying more frequently, all whilst keeping business critical data secure? Take part in the survey for an advanced copy of the …

Datatypes and the Default Mask with Dynamic Data Masking

Publié le 9 novembre 2018 sur sqlservercentral.com
 

This article digs deeper into the ways that Dynamic Data Masking works with different data types.

Unused Indexes – Are they really unused or have they just not been used YET?

Publié le 9 novembre 2018 sur sqlservercentral.com
 

Tara explains when index DMVs gets reset by telling a story from her dark past.

SQL SERVER – The Older Way to Find Size of Index Using Deprecated sysindexes

Publié le 9 novembre 2018 sur journey to sqlauthority
 

Earlier this month, I wrote a blog post about How to Find Size of the Index for Tables? – Interview Question of the Week #198, in this I had explained the way to find the size of the index for the table. However, while I was writing the blog …

PASS Summit 2018 Keynote Day 2: Live Blog

Publié le 8 novembre 2018 sur brentozar.com
 

Today is the second day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Yesterday, we got the marketing keynote that caught attendees up with the current state of SQL Server 2019 and Azure services. The atten …

T-SQL Decommenter Part I

Publié le 8 novembre 2018 sur sqlservercentral.com
 

Introduction to a T-SQL query that remove comments from T-SQL code

Help Redgate improve Data Masker for SQL Server?

Publié le 8 novembre 2018 sur sqlservercentral.com
 

Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new re …


Pages :