Sites anglophones

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

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 …

Representing XML data in SQL Server

Publié le 7 août 2018 sur

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

Steps to Migrate Oracle Database to Azure SQL Database

Publié le 7 août 2018 sur

In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or pl …

SQL SERVER – Setting ARITHABORT ON for All Connecting .Net Applications

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

Readers of this blog post are aware of SQL Server Expert Tim Cartwright, who has previously written an enhanced version of How to Generate Random Password script. Here is another very interesting find by Tim on the subject of ARITHABORT ON se …

Two Important Differences Between SQL Server and PostgreSQL

Publié le 6 août 2018 sur

SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I’ve spent a lot of time writing Postgres queries lately. Here are some of the things I’ve noticed that are different. CTEs are optimiz …

The ‘Right to be Forgotten’ and Data Masker for SQL Server

Publié le 6 août 2018 sur

The right to be forgotten is one of the main features of new data protection legislation across the globe. Under Article 17 of one such piece of legislation in Europe, the GDPR, individuals have the right to have personal data erased from all systems a …

SQL Server Data Table as CRM Data Source on VBA Form

Publié le 6 août 2018 sur

Using SQL SERVER Database as Data Source FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.

How to Successfully Deliver IT Projects in a Not-so-Agile Organization

Publié le 6 août 2018 sur

Agile methodology for software delivery is accepted at many organizations but is not used everywhere. In this article, Mohammad Rizvi gives advice on how to successfully implement a software project in a non-Agile environment. How to fix SQL Server dis …

Pages :