Sites anglophones


Things SQL Server Setup Doesn’t Do – And Should

Publié le 30 mai 2019 sur brentozar.com
 

During the setup wizard, SQL Server should ask for your email address. It should suggest that you use a distribution list for people on your team, so that someone gets the alerts when you’re out on vacation. Then, it should send these common fail …

Unit Testing, Databases, and You

Publié le 30 mai 2019 sur simple-talk.com
 

One of the biggest complaints I experience is that of developers and end users who run into bugs. GASP! It’s a four-letter word (only because I pluralized it, right, but it counts). When one reflects on those bugs, one of the biggest causes for t …

How Monitoring Can Help Keep Your SQL Server Estate Secure?

Publié le 30 mai 2019 sur journey to sqlauthority
 

While monitoring might be common practice for keeping databases running smoothly, this is often directed at maintenance tasks such as query performance or future planning. Sometimes this will include some checks for security, but these tend to be limit …

Connect to Sybase with a Linked Server

Publié le 30 mai 2019 sur sqlservercentral.com
 

Yesterday I spent a lot of time with quite a simple problem: how to connect to a Sybase database server from SQL Server. It was a neverending story to search up tips and ideas and put them together. After a long time spent testing ideas, I found a simp …

Enhance your database development by using coding standards

Publié le 30 mai 2019 sur sqlservercentral.com
 

The post Enhance your database development by using coding standards appeared first on SQLServerCentral.

Introduction to SQL Server Security — Part 6

Publié le 29 mai 2019 sur simple-talk.com
 

The series so far: Introduction to SQL Server Security — Part 1 Introduction to SQL Server Security — Part 2 Introduction to SQL Server Security — Part 3 Introduction to SQL Server Security — Part 4 Introduction to SQL Server Se …

SQL SERVER – The Future of DevOps for DBA

Publié le 29 mai 2019 sur journey to sqlauthority
 

Unless you are living under rocks, you would have heard the word DevOps. I am sure you many of you are working on the DevOps as well and have a clear idea about what is DevOps. To be super honest, I still see people who are not sure what actually DevOp …

SQL Server Triggers Pros and Cons

Publié le 29 mai 2019 sur sqlservercentral.com
 

The post SQL Server Triggers Pros and Cons appeared first on SQLServerCentral.

4 steps to standardize your database development processes

Publié le 29 mai 2019 sur sqlservercentral.com
 

The post 4 steps to standardize your database development processes appeared first on SQLServerCentral.

SQL in the City Summits Down Under

Publié le 29 mai 2019 sur sqlservercentral.com
 

The post SQL in the City Summits Down Under appeared first on SQLServerCentral.

Glenn’s Tech Insights For May 28, 2019

Publié le 28 mai 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

User-defined scalar functions suck – even when they don’t access data.

Publié le 28 mai 2019 sur brentozar.com
 

The performance of scalar functions sucks hard. Let’s see it in action using the Stack Overflow database – any size will work. I’ll set things up first in case you want to follow along: USE StackOverflow2013; GO ALTER DATABASE CURRENT …

SQL Server Plan Cache Limits

Publié le 28 mai 2019 sur SQLSkills.com - Erin Stellato
 

Last week on SQLPerformance.com I blogged about ad hoc workloads and how they impact performance, noting plan cache bloat, and I had a comment asking about SQL Server plan cache limits.  Kimberly mentions them in her classic post Plan cache and op …

SQL SERVER – An Index Reduces Performance of SELECT Queries

Publié le 28 mai 2019 sur journey to sqlauthority
 

Can an Index reduce the performance of SELECT Queries? Let me make this question a bit more complete –Can an Index reduce the performance of SELECT Queries even though that index is not used anywhere?If your answer is NO, well, continue read …

Insert Statement Without Column List (BP004)

Publié le 28 mai 2019 sur sqlservercentral.com
 

The post Insert Statement Without Column List (BP004) appeared first on SQLServerCentral.


Pages :