Sites anglophones


[Video] Free Training of the Week: How to Configure Quorum for SQL Server

Publié le 31 janvier 2016 sur brentozar.com
 

This year, we’re trying something new: every Monday, we’re going to show you one module out of our online training classes. It’s the whole module, not a sneak peek, and it’s available the whole week. But you’d better not p …

Interview Question of the Week #056 – How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server

Publié le 31 janvier 2016 sur journey to sqlauthority
 

Sometimes in the interviews I observe that users are able to answer all the theoretical questions correct but when it is about doing practical they fail. A while ago, when I was helping a large organization with interview, suddenly their DBA reported t …

SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’

Publié le 30 janvier 2016 sur journey to sqlauthority
 

I do apply patches to my SQL instances as and when they are released by Microsoft. This is important because I always feel keeping the bits uptodate is essential because I don’t want to get infected as I travel quite a bit. Since I play a lot wit …

SQL Server Diagnostic Information Queries Detailed, Day 30

Publié le 29 janvier 2016 sur sqlskills.com - glen berry
 

For Day 30 of this series, we start out with Query #67, which is UDF Statistics. This query retrieves information from the sys.dm_exec_function_stats dynamic management view about aggregate runtime metrics for user-defined functions in the current data …

My Best Blog Posts from 2015

Publié le 29 janvier 2016 sur sqlblog.com
 

ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in which I blogged. Namely – simply reposting a slight variant of a given blo …

Top Insights You Can Gain from the Usage Stats Dynamic Management View (Part 1)

Publié le 29 janvier 2016 sur sqlmag.com
 

Valuable insights are available about your indexing strategy through the Dynamic Management Views: one in particular. read more

SQL Server Diagnostic Information Queries Detailed, Day 29

Publié le 29 janvier 2016 sur sqlskills.com - glen berry
 

For Day 29 of this series, we start out with Query #65, which is XTP Index Usage. This query retrieves information from the sys.dm_db_xtp_index_stats dynamic management view and the sys.indexes object catalog view about the overall in-memory OLTP index …

Data Integration is the Foundation

Publié le 29 janvier 2016 sur sqlblog.com
 

Unless you live under a rock, you’ve seen the buzz about Data Lakes, Big Data, Data Mining, Cloud-tech, and Machine Learning. I watch and read reports from two perspectives: technical and as a consultant. As a Consultant If you watch CNBC, you wo …

[Video] Office Hours 2016/01/27

Publié le 29 janvier 2016 sur brentozar.com
 

In this week’s Office Hours Q&A, we talk about the pains of patching lots of SQL Servers, how to move databases from one drive to another with minimal downtime, the difference between NOLOCK and READ UNCOMMITTED, and assign Doug all future ca …

Using the Statistical Program R for Running Statistics

Publié le 29 janvier 2016 sur sqlservercentral.com
 

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.

SQL SERVER – 2016 Error Reasons: Msg 10778, Level 16 Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported

Publié le 29 janvier 2016 sur journey to sqlauthority
 

When I was writing the blog SQL SERVER 2016 – InMemory OLTP support for Foreign Key, it felt like a great addition to SQL Server. I felt there must be something that I might be missing as the obvious. I was not wrong in that feeling too. One of m …

SQL Server Diagnostic Information Queries Detailed, Day 28

Publié le 28 janvier 2016 sur sqlskills.com - glen berry
 

For Day 28 of this series, we start out with Query #63, which is Overall Index Usage – Reads. This query retrieves information from the the sys.indexes object catalog view, and the sys.dm_db_index_usage_stats dynamic management view about the ove …

Should I Worry About Index Fragmentation?

Publié le 28 janvier 2016 sur brentozar.com
 

Here’s a handy flowchart for whenever you find yourself worrying about fragmentation: *Talk to your doctor about whether fragmentation is a problem for you. Seek help for index maintenance lasting longer than four hours. Serious side effects may …

Database on a diet (Part 1)

Publié le 28 janvier 2016 sur sqlblog.com
 

Hi Folks, My next article for SQL Server Magazine is out now. I’ve decided that New Year is the time that most people discuss diets and databases don’t have to be an exception. I’m discussing one large client who had a database that r …

Manipulating Filetable Files Programatically

Publié le 28 janvier 2016 sur sqlservercentral.com
 

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer


Pages :