Sites anglophones


Deploying Multiple SSIS Projects via PowerShell

Publié le 27 février 2017 sur simple-talk.com
 

Overview This article describes a way of using PowerShell to deploy multiple SSIS projects as part of a database or data warehouse deployment. It contains code snippets to illustrate some of the details, and so you can amend it for similar requirements …

Exploring Azure Storage for SQL Server DBAs – Part 2

Publié le 27 février 2017 sur simple-talk.com
 

In my previous article, we went over how Azure storage affects the performance of our hosted virtual machines running SQL Server. We looked at the different ways in which performance is throttled, and talked about how to get your environment setup in t …

[Video] Office Hours 2017/02/22 (With Transcriptions)

Publié le 27 février 2017 sur brentozar.com
 

This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more. Here’s the video on YouTube: You …

The Last Week for SQL Bits 2017 Discounts

Publié le 27 février 2017 sur sqlservercentral.com
 

This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.

Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data

Publié le 27 février 2017 sur sqlservercentral.com
 

SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more …

Performance Dashboard Error: Could not find stored procedure

Publié le 27 février 2017 sur sqlservercentral.com
 

In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.

SQL SERVER – Maintenance Plan failing with 0x80131904 – A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Publié le 27 février 2017 sur journey to sqlauthority
 

One of my clients contacted me and informed that after patching of SQL Server, they noticed that their maintenance plan were failing. I asked them to share the complete error message about the Maintenance Plan failing with 0x80131904. End Warning …

Music City Code, a great conference that you may have never heard of yet

Publié le 27 février 2017 sur sqlblog.com
 

For quite a few years, Nashville, and then Chattanooga had a conference called Devlink. It was low on cost, and high on education, and run by the awesome John Kellar ( @johnkellar ), who wrote the forward of my 2012 book. It was an amazing conference a …

How to do Pagination in SQL Server? – Interview Question of the Week #111

Publié le 26 février 2017 sur journey to sqlauthority
 

Question: How to do Pagination in SQL Server? Answer: A very popular question during interviews, which often stumps the candidate. I have helped many organizations to hire the right talent for many years and I know that this one question often thr …

SQL SERVER – Event ID 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name)

Publié le 25 février 2017 sur journey to sqlauthority
 

While trying to start SQL Service for a named instance, I got an error message related to event id 26 – Your SQL Server Installation is Either Corrupt or has Been Tampered With (Error Getting Instance Name). Here is the text of the error whi …

2017 Training Resolutions from the SQL Cruise Technical Leads

Publié le 24 février 2017 sur sqlmag.com
 

Granted calendars as we know them are subjective and not all cultures honor the same calendar but we are at that time of the year that is known for setting resolutions for the coming twelve months and I thought it would be an interesting exercise to se …

I’m just saying it’s valid T-SQL syntax, that’s all.

Publié le 24 février 2017 sur brentozar.com
 

Bad idea #1 Bad idea #2 Bad idea #3

SQL SERVER – Fix: Error: 1934, Level 16, INSERT or UPDATE Failed Because the Following SET Options have Incorrect Settings: ‘QUOTED_IDENTIFIER’.

Publié le 24 février 2017 sur journey to sqlauthority
 

A very old client of mine yesterday pinged me with this question about error related to QUOTED_IDENTIFIER. “Pinal, When I run my query it works just fine in SSMS but when I run it via SQL Server Agent Job, it gives me following error. Can yo …

Doing Fuzzy Searches in SQL Server

Publié le 23 février 2017 sur simple-talk.com
 

When an application searches for specific text data, you can generally rely on it to get the search term right. For example, if it needs to find ‘sausages’, you won’t expect to receive a search on ‘sossyjez’. , however, Wh …

SQLskills SQL101: SQL Server Maintenance

Publié le 23 février 2017 sur sqlskills.com - glen berry
 

Microsoft has a methodology for developing and distributing updates to SQL Server, which they call the Incremental Servicing Model (ISM).  This model has a hierarchy of on-demand hotfixes (HFs), Cumulative Updates (CUs), and Service Packs (SPs) th …


Pages :