Sites anglophones

Setting mentoring ground rules

Publié le 6 février 2018 sur - paul randall

One of the things I always recommend in the first newsletter of each year is to try to get a mentor. On the flip side of that is that one of the most rewarding things you can do in your professional life is to *be* a mentor to one or more people. I men …

How to Survive as a Lone DBA

Publié le 6 février 2018 sur

I was a Lone DBA for over 15 years and during that time I have learned a thing or two about how to survive on my own in relatively large environments. In this article, I will share with you some of the big things I learned during those years that may h …

T-SQL Tuesday #99 : Dealer’s Choice

Publié le 6 février 2018 sur

T-SQL Tuesday #99 invitation……(read more)

The Annals of Hilariously Bad Code, Part 1: Critique the Code

Publié le 6 février 2018 sur

Hey Beavis That’s the first time I’ve used “annals” correctly. I will be 40 sooner than later. Sometimes when we blog, we get inspiration from clients, students, other bloggers, questions on Stack Exchange, nightmares, or just d …

SQL Server Replication for Temporal Tables

Publié le 6 février 2018 sur

In this tip, Ameena Lalani looks at how you can setup replication to include temporal history data.

SSIS Package with a Derived Column

Publié le 6 février 2018 sur

I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which …

Realistic, simulated data for testing, development and prototypes

Publié le 6 février 2018 sur

This article proposes a scheme for using Redgate SQL Data Generator (SDG) as a ‘data generation and translation’ tool. We generate the data using a free copy of SQL Server Express, and then use standard bulk copy mechanisms to translate it …

SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly

Publié le 6 février 2018 sur journey to sqlauthority

Sometimes there are unexpected errors and it’s always fun to find the cause of them. In this blog, we would learn about fixing an error which I received while doing create catalog from SQL Server Management Studio. The text of the complete messag …

SQLskills SQL101: How You Can Make Your Database Backups More Reliable

Publié le 5 février 2018 sur - glen berry

SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or where there are many misunderstandings that …

Things I Have Not Heard Recently

Publié le 5 février 2018 sur

“No, don’t bother the DBA. It’s probably not a database problem.” “But it says right here that it worked on my machine.” “Solid state storage sure is overrated.” “Thank God for auto-shrink, really s …

Bringing DevOps to the database. Part 1: Version control

Publié le 5 février 2018 sur

Continuous delivery, continuous integration, automated release management – the phrases alone are enough to make the talk about DevOps for the database sound more complicated than it actually is – this post explains that the key is to start small …

Configure Read Only Routing

Publié le 5 février 2018 sur

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.

Add a SQL Server Database to an Existing Always On Availability Group

Publié le 5 février 2018 sur

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.

SQL SERVER Data Tools – SSDT for Visual Studio 2017 Installation Error 0x80070002: Error 0x80070002: Failed to Acquire Payload

Publié le 5 février 2018 sur journey to sqlauthority

I was trying to build a new machine for my demo purposes and wanted to install everything possible related to Data. SQL Server Data Tools (SSDT) is also needed to complete the package. I downloaded it from here. But I was not able to install it! I foll …

[Video] Office Hours 2018/1/17 (With Transcriptions)

Publié le 4 février 2018 sur

This week, Tara, Erik, and Richie discuss 3rd-party tools for object-level restore, patching, stringing multiple CTEs, Meltdown and Spectre, instance stacking, organizing DBA teams, DBCC checks, moving local databases to Amazon RDS, CTEs vs temp tables …

Pages :