Sites anglophones


Using AT TIME ZONE to fix an old report

Publié le 27 mars 2017 sur sqlservercentral.com
 

Rob Farley contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user’s time zone. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis exp …

SQL SERVER – The Lease between Availability Group ‘PRODAG’ and the Windows Server Failover Cluster has Expired

Publié le 27 mars 2017 sur journey to sqlauthority
 

This is one of the common errors I have seen while working with customers who are using SQL Server AlwaysOn availability groups. Once this error comes, the resource in the cluster goes to failed state and in SQL Server Management Studio, we should be a …

We’re Changing Our Online Training – Here’s Why.

Publié le 26 mars 2017 sur brentozar.com
 

“Who replaced my SQL Server book with a cookbook?” When we launched our self-paced online training classes, we packaged them as focused courses that addressed a single pain point like: How to Tune Indexes and Speed Up SQL Server How to …

What is the Difference between SUSPECT and RECOVERY PENDING? – Interview Question of the Week #114

Publié le 26 mars 2017 sur journey to sqlauthority
 

Question: What is the Difference between SUSPECT and RECOVERY PENDING? Answer: Sometimes I get messages on Skype about some quick suggestions/ideas and if I am free, I do help them. One of the blog readers pinged me and said that they have moved a …

March 2017 update for SDU Tools–More free tools for SQL Server developers and DBAs

Publié le 25 mars 2017 sur sqlblog.com
 

Hi Folks, As promised, tonight we’re releasing the monthly update to SDU Tools, our free toolset for SQL Server developers and DBAs. A download link will be sent to all registered subscribers. First, the new tools: AnalyzeTableColumns – allows fo …

Speaking at the SQL Server Seattle User Group in April

Publié le 25 mars 2017 sur sqlblog.com
 

I’m happy to share that I’ll be speaking at the next SQL Server Seattle User Group meeting on April 13th. The topic is again Temporal Tables a subject I love a lot and that is 100% useful in possible roles: dev, dba or bi guy. Temporal Tabl …

SQL SERVER – Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors

Publié le 25 mars 2017 sur journey to sqlauthority
 

This error is one of an interesting which appeared as soon as we right click on the database. It says Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors. Due to this error, we were not able to see the …

PASS Business Analytics Marathon (March 2017)

Publié le 24 mars 2017 sur sqlblog.com
 

The next edition of the live event PASS Business Analytics Marathon will be on March 29, 2017.This edition of Business Analytics Marathon will consist of five webinars on the following topics:Data Driven StorytellingData DiscoveryPower BIThe sched …

5 Signs Your SQL Server Isn’t Wearing Pants

Publié le 24 mars 2017 sur brentozar.com
 

We see a lot of SQL Servers. During our sales process, prospective customers run sp_Blitz on their SQL Server, and we talk through the results. I see a lot of horrifying stuff. Over time, I’ve built up a pretty good sense of signs that a SQL Serv …

SQL SERVER – Jump in Identity Column After Restart

Publié le 24 mars 2017 sur journey to sqlauthority
 

The SQL Product team makes a continuous change in the product which sometimes causes unpredictable behaviors in the SQL Server engine. One of such change was done in SQL Server 2012 which caused the behavior which I just said in the subject line Identi …

Upgrading to SQL Server 2016: New Data Privacy and Security Features

Publié le 23 mars 2017 sur sqlmag.com
 

Thomas LaRock, Head Geek, SolarWinds Released last June, Microsoft SQL Server 2016 has been available for about eight months, even longer if you were using one of the CTP versions as far back as 2015. Now well into the New Year, if they …

From The Mailbag: DBCC CHECKDB And Read Only Databases

Publié le 23 mars 2017 sur brentozar.com
 

We got an email!!! It was weird. It was from an Australian, and it was right side up. I could hardly believe it. Normally we encourage people to ask us questions during Office Hours, or over on Stack Exchange. That way lots of people can benefit from t …

Getting Started with Azure SQL Data Warehouse – Part 2

Publié le 23 mars 2017 sur sqlservercentral.com
 

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.

Comparing Space Usage for Different Compression Types

Publié le 23 mars 2017 sur sqlservercentral.com
 

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.

SQL SERVER – AlwaysOn Listener Error – The WSFC Cluster Could Not Bring the Network Name Resource With DNS Name ‘DNS name’ Online

Publié le 23 mars 2017 sur journey to sqlauthority
 

I can tell you how many times I have heard about this error. This can appear in any of the situation where SQL needs to create a cluster network name resource in the WSFC Cluster. Here are the two situations I can think of: Installing SQL Server Failov …


Pages :