Sites anglophones

First Responder Kit Release: A Year From Now These Will All Stop Working On 2008 And 2008R2

Publié le 10 août 2018 sur

You think I’m kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the updated here. sp_Blitz Improvements#1664 – We’re officially smart enough to not warn people that we’re r …

The First 3 Things I Look At on a SQL Server

Publié le 10 août 2018 sur

1. Are backups and CHECKDB being done? Before I step out on the wire, I want to know if there’s a safety net. If there’s a recoverability risk, I don’t stop here – I keep looking because the rest of the answers affect the safety …

Learning about FOR JSON

Publié le 10 août 2018 sur

Links and information about the FOR JSON clause in SQL Server 2016.

SQL SERVER – WMI Error 0x80041017 – Invalid Query Using WBEMTest

Publié le 10 août 2018 sur journey to sqlauthority

During my free time, I do provide assistance to the community. Sometimes via forums, sometimes by giving a free session to local user group related to SQL Server. In this blog, I would share the steps to fox WMI error 0x80041017, Invalid Query. In one …

How to Check for Non-Existence of Rows

Publié le 9 août 2018 sur

You’re writing a query, and you wanna check to see if rows exist in a table. I’m using the free Stack Overflow database, and I wanna find all of the users who have not left a comment. The tables involved are: In dbo.Users, the Id field …

The march of DevOps from the backroom to the boardroom

Publié le 9 août 2018 sur

By encouraging collaboration and teamwork, removing the barriers between development and operations, and introducing automation, DevOps speeds up software delivery and enables features to move from the fingers of developers into the hands of customers …

Using a CTE as a Tally Table

Publié le 9 août 2018 sur

Sometimes you need to output blank lines – in effect displaying Records for Missing Data. This article explains how to use a CTE to do this

The Top Five Things That DBAs Need to Monitor

Publié le 9 août 2018 sur

Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are t …

SQL SERVER – Install Error – The Reporting Services Catalog Database File Exists. Select a Reporting Services files-only mode installation

Publié le 9 août 2018 sur journey to sqlauthority

One of my clients was doing a remote installation of SQL Server via command prompt. During the testing phase, they encountered an error. In this blog, we would learn how to fix error The Reporting Services catalog database file exists. When they contac …

Introduction to PowerShell with SQL Server Using Invoke-SQLCMD

Publié le 8 août 2018 sur

One of the most valuable tools I’ve seen added to my toolkit over the years is PowerShell. While I had gotten very adept at writing some pretty complex CMD files, PowerShell has opened up whole new possibilities. Often now when a client says, …

Why Does My Select Query Have An Assert?

Publié le 8 août 2018 sur

You And Ert This is a quick post because it came up with a client. I like having stuff to point people to — that’s sort of like automation, right? Anyway! Lots of plans have Assert operators in them. But they’re usually performing mod …

SQL Server Index Tutorial Overview

Publié le 8 août 2018 sur

Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA’s toolbox that is used when we are trying to improve the performance of a query.

SQL SERVER – FIX: Error 17836: Length Specified in Network Packet Payload Did Not Match Number of Bytes Read; the Connection has been Closed

Publié le 8 août 2018 sur journey to sqlauthority

One of my clients reported that they are seeing below error in SQL Server ERRORLOG. He noticed a strange error of the network packet. 2018-08-06 07:09:41.363 Logon Error: 17836, Severity: 20, State: 17. 2018-08-06 07:09:41.363 Logon Length specified in …

A Visual Guide to Choosing an Index Type

Publié le 7 août 2018 sur

Warning: I’m about to overly simplify a whole lot of topics to make things easy. Armchair architects, warm up your flamethrowers. Your table has rows and columns kinda like a spreadsheet: In most applications, your users care about all of the row …

Join Redgate’s SQL data catalog early access program

Publié le 7 août 2018 sur

Redgate wants your help to develop a product for SQL Server data classification that meets today’s compliance and DevOps needs. If you’re interested in taking part in research and providing feedback on new releases, please register for the …

Pages :