Sites anglophones


SQL Server 2016 Cumulative Updates (August 2017)

Publié le 14 août 2017 sur sqlblog.com
 

Microsoft has released the following Cumulative Updates for SQL Server 2016 (RTM and SP1). Cumulative Update 7 for SQL Server 2016 RTM KB 4024304DownloadBuild number: 13.0.2210.0SQL Release Services blog postCumulative Update 4 for SQL S …

SQL Cruise Alaska 2017 Kicks Off

Publié le 14 août 2017 sur sqlmag.com
 

August 12, 2017 marked the first day of Tech Outbound’s SQL Cruise Alaska. After 3 years away, SQL Cruise returned to Seattle under hazy skies from the forest fires burning in Central British Columbia. read more

Using multiple custom SQL formatting styles in SQL Prompt

Publié le 14 août 2017 sur sqlservercentral.com
 

Usually, when coding SQL, you will want to go along with the coding style of the team you are working with. This article shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to swi …

SQL Server Management Studio Tips

Publié le 14 août 2017 sur sqlservercentral.com
 

Complete guide about hidden gems of SSMS

SQL Server function to check dynamic SQL syntax

Publié le 14 août 2017 sur sqlservercentral.com
 

Although most of what you read tells you to stay away from dynamic SQL, the reality is there are places where writing T-SQL code dynamically just makes sense. The one downside to dynamic SQL is that if it is not written correctly the code will fail. El …

SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started

Publié le 14 août 2017 sur journey to sqlauthority
 

Many companies do hardening of servers to make sure they are protected from any known vulnerabilities. It is important to test all the application in test server before doing hardening. Let us learn about how to fix Eventlog Service not starting. Recen …

Row Level Security and Indexed Views

Publié le 14 août 2017 sur sqlblog.com
 

I was giving my Row Level Security session last weekend for the Richmond User Group ( @RichmondSQL   http://rva.pass.org/) and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally sp …

Upgrading SQL Server–Day 13

Publié le 13 août 2017 sur sqlskills.com - glen berry
 

Another relatively quick and easy way to do a Production migration of data from one place to another or from an older version of SQL Server to a newer version of SQL Server is to use database mirroring. You have to have each user database in Full recov …

How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135

Publié le 13 août 2017 sur journey to sqlauthority
 

Question: How to Show Results of sp_spaceused in a Single Result? Answer: When I hear this question from my co-interviewer, I objected. I think it is not a good interview question. I do not expect any of the candidates to remember any of the synta …

Upgrading SQL Server–Day 12

Publié le 12 août 2017 sur sqlskills.com - glen berry
 

One easy and quick way to do a Production migration of data from one place to another or from an older version of SQL Server to a newer version of SQL Server is to use log shipping. Log shipping may not be new and shiny like availability groups, but it …

Abstracts Open for GroupBy December

Publié le 12 août 2017 sur brentozar.com
 

Want to present at the upcoming GroupBy December 1 & 8 online conference? Read the abstracts submitted so far Submit your own abstract Readers will comment on your abstract, helping you improve it (so don’t kill yourself working really hard o …

Memory Allocated To Plan Caching

Publié le 12 août 2017 sur sqlblog.com
 

I could complain about Entity Framework, but there is probably nothing that has not already been aired. So instead, I will complain about the lack of tuning options in SQL Server’s Memory Allocated To Plan Caching. As of SQL Server versions 2005 SP2 an …

Failed to update the database because the database is read-only

Publié le 12 août 2017 sur sqlblog.com
 

Had a client today asking about this situation. They were working away on a machine and suddenly they got the message “Failed to update the database because the database is read-only”. The user hadn’t changed anything that they were a …

SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?

Publié le 12 août 2017 sur journey to sqlauthority
 

Question: How to Clear Plan Cache with Scoped Configuration? Answer: Database Scoped Configuration is a relatively new feature introduced in SQL Server 2016 and will be continued for the future version of SQL Server. In SQL Server Management Studi …

Upgrading SQL Server–Preferred AMD EPYC 7000 Processors

Publié le 11 août 2017 sur sqlskills.com - glen berry
 

Yesterday I talked about the critical importance of thoughtful processor selection for SQL Server as part of the upgrade and migration process, and I supplied a list of “preferred” Intel Scalable Processor family (Skylake-SP) processors at …


Pages :