Sites anglophones

Batch SSIS pkg execution from Business Intelligence Development Studio

Publié le 11 juillet 2017 sur

The Execute Package Task and a second instance of Business Intelligence Development Studio can be a satisfactory method of background execution of SSIS packages in batch mode when you don’t have access to Integration Services.

PASS SQL Saturday #687 Slovenia 2017

Publié le 11 juillet 2017 sur

Here we go for the fifth time! The leading event dedicated to Microsoft SQL Server in Slovenia, PASS SQL Saturday #687, will take place on Saturday, December 9th 2017, at the Faculty of Computer and Information Science of the University of Ljubljana, V …

Learning the hard way – referenced objects or actual objects

Publié le 11 juillet 2017 sur

This month’s T-SQL Tuesday is about lessons we’ve learned the hard way. Which, of course, is the way you learn best. It’s not the best way to learn, but if you’ve suffered in your learning somewhat, then you’re probably go …

SQL SERVER – How to Pass Parameters to the Stored Procedure?

Publié le 11 juillet 2017 sur journey to sqlauthority

After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. Every other day I receive a question in an email asking how to pass parameters to the stored procedure. Today, I decided …

[Video] Office Hours 2017/07/05 (With Transcriptions)

Publié le 10 juillet 2017 sur

This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar Unlimited, and wh …

T-SQL Window Functions

Publié le 10 juillet 2017 sur

I’ll soon post something on this, but let me tell you right here. If you don’t want AI to take you DEV/DBA/BI job you *need* to be smarter than AI (which is not AI at all right now, but let’s keep on playing the marketing game): one w …

Cloning Security Objects Between Servers

Publié le 10 juillet 2017 sur

Looking to avoid issues with SID mis-match, password synchronization, orphaned logins, and missing server role membership with working with test, UAT, dev, or training instances of your SQL Servers? Read on for how to make this process much easier betw …

I’m on the new SQLPlayer Podcast

Publié le 10 juillet 2017 sur

Me, Damian Widera, and Kamil Nowinski in Wroclaw On my Poland trip, I sat down with Kamil Nowinski and Damian Widera to talk about how I got started with presenting, why I don’t use PowerShell (but you should), how sp_Blitz ended up on Github, my …

What You Need To Know About DR Testing

Publié le 10 juillet 2017 sur

Practice makes perfect. That’s true of everything, including disaster recovery. If you aren’t already testing your DR plan, you should be – here’s what you need to know to get started.

Introduction to Azure SQL Datab Sync

Publié le 10 juillet 2017 sur

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Pre …

Azure DWH part 10: WPF and Azure SQL Data Warehouse

Publié le 10 juillet 2017 sur

In this article, we will show how to create a WPF application ans show how to insert data to ASDW. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix …

SQL SERVER – Running CHECKDB with Minimum Repair Level

Publié le 10 juillet 2017 sur journey to sqlauthority

“How do I run CHECKDB with Minimum Repair Level?” When you run a blog with a million views a month, one must expect every kind of audience on the blog and author should be not judge every single email. It is almost impossible to correct the …

What’s in a name? How should SQL Server 2017 Graph Edge tables be named?

Publié le 10 juillet 2017 sur

Dennes Torres recently wrote a really excellent article introducing Graph Objects in SQL Server 2017. You’ll find it here: I’ve also recently publ …

What does BACKUP WITH NAME Command do? – Interview Question of the Week #130

Publié le 9 juillet 2017 sur journey to sqlauthority

Questions: What does BACKUP WITH NAME Command do? Answer: Nothing more than naming your database backup. Honestly, I was recently asked this question by a user and I was a bit lost when I heard this one. To find the answer, I had to search the internet …

SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port

Publié le 8 juillet 2017 sur journey to sqlauthority

Microsoft SQL Server has given an option to connect to SQL Server when normal connections can’t be made because of any reasons. This feature is called as Dedicate Administrator Connection (DAC). You can read more about DAC over here. Diagnostic C …

Pages :