Sites anglophones


SQL SERVER – Configure Stored Procedure to Run at Server Startup – Simple Tutorial

Publié le 16 octobre 2017 sur journey to sqlauthority
 

One of the most popular questions I received during my SQL Server Performance Tuning Practical Workshop is how users can run sets of procedure when their SQL Server starts automatically.  Today, let us see a simple tutorial to run stored procedure …

[Video] Office Hours 2017/10/11 (With Transcriptions)

Publié le 15 octobre 2017 sur brentozar.com
 

This week, Brent, Erik, and Richie discuss the new Extended Events Profiler, using SQL audit vs a trigger to log what people do, log shipping, migrating from on-prem to cloud, best practice for a database owner, SQL Server performance improvement, the …

Can You DROP Offline Database? – Interview Question of the Week #143

Publié le 15 octobre 2017 sur journey to sqlauthority
 

Question: Can You DROP Offline Database? Answer: Ofcourse Yes. Before you jump and say you knew this one. Well, super. As I always say you know your stuff. Now for the rest of the people who did not know about this, let me give some context behind …

SQL SERVER – Empty Startup Parameters in SQL Server Configuration Manager

Publié le 14 octobre 2017 sur journey to sqlauthority
 

While testing a scenario for my client, I ran into a behavior which I was not aware of. Let us learn about the error which is related to Empty Startup Parameters in SQL Server Configuration Manager. I logged in to the virtual machine (my lab envir …

Loading partitions incrementally using SSIS

Publié le 13 octobre 2017 sur sqlservercentral.com
 

In the article, Keeping Fact Tables Online while Loading via Partition Switching1, we discussed that for very large fact tables where each partition is very large, it is not practical to load partitions completely. Hence for these tables, you would wan …

How to Log Wait Stats to Table with sp_BlitzFirst

Publié le 13 octobre 2017 sur brentozar.com
 

When you’re analyzing SQL Server performance, one of the best places to start is wait stats. What’s your SQL Server waiting on? sp_BlitzFirst makes it really easy to trend this data over time for free with all currently supported versions o …

How to import an existing database to ReadyRoll

Publié le 13 octobre 2017 sur sqlservercentral.com
 

The SQL Toolbelt includes ReadyRoll, which allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with ReadRoll, and customers often ask how to get up and ru …

A Freecon Halloween at the PASS Summit

Publié le 13 octobre 2017 sur sqlservercentral.com
 

If you’re attending the PASS Summit in 2017, there’s a Freecon day on Tuesday you can attend.

SQL SERVER – Msg 1038 – An Object or Column Name is Missing or Empty. For SELECT INTO Statements, Verify Each Column Has a Name

Publié le 13 octobre 2017 sur journey to sqlauthority
 

Along with my freelance work as an independent consultant, I do keep an eye on various forums and look at issue reported with solutions so that I can blog about them to help the community. One of the Facebook group where I am active is SQLBangalore and …

How to Do a SQL Server Architecture Review

Publié le 12 octobre 2017 sur brentozar.com
 

We’ve talked about how to do a free SQL Server health check, and then how to drill deeper with performance check. After these two, management usually steps back and asks, “Wait a minute – how’d we get into this mess? And long te …

Graph Matching with T-SQL Part 3: Maximum Matching

Publié le 12 octobre 2017 sur sqlmag.com
 

This article is the third part in a series about graph matching tasks. read more

The importance of bringing Python to SQL Server

Publié le 12 octobre 2017 sur sqlservercentral.com
 

When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. But why Python and SQL Server? What is Python? And how does this compare to the …

Group Managed Service Accounts (gMSAs) in SQL2016

Publié le 12 octobre 2017 sur sqlservercentral.com
 

Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON

Puppet and Google Partner on Cloud On-Ramp

Publié le 12 octobre 2017 sur sqlmag.com
 

Alphabet is hoping to leverage Puppet’s cloud-native tools to help attract enterprises with mature software to its cloud.

SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days

Publié le 12 octobre 2017 sur journey to sqlauthority
 

Just the other day one of my customers asked me that they are facing a situation where they have specified in their backup script RETAINDAYS option but it is actually not deleting their older database backups. I get this question quite a lot of ti …


Pages :