Sites anglophones


Going Interactive with C#

Publié le 11 octobre 2016 sur sqlservercentral.com
 

For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, wit …

SQL SERVER – Performance Benefit of Using SPARSE Columns?

Publié le 11 octobre 2016 sur journey to sqlauthority
 

I have written a number of blogs around working with SPARSE Columns in the past and a primer to what SPARSE Columns can be got from the list mentioned: SQL SERVER – 2008 – Introduction to SPARSE Columns SQL SERVER – 2008 – Intro …

[Video] Office Hours 2016/10/05 (With Transcriptions)

Publié le 10 octobre 2016 sur brentozar.com
 

This week, Brent, Richie, Tara, and Erik discuss their learning styles, Always On Availability Groups, memory leaks, Windows updates, how to transition from developer to DBA, upgrading SQL server from 2008 to 2014, temp tables vs table variables, and h …

MDX Calculations Across Multiple Calendars Using Nested SCOPEs

Publié le 10 octobre 2016 sur sqlservercentral.com
 

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step ho …

Azure SQL Database – Azure AD Authentication

Publié le 10 octobre 2016 sur sqlservercentral.com
 

One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabiliti …

SQL SERVER – Error: Property BackupDirectory is Not Available for Settings

Publié le 10 octobre 2016 sur journey to sqlauthority
 

I break a lot of things on my SQL environment and I believe that is a very good way to learn things. Today, I wanted to perform a restore of a database using a backup which I took earlier. In this blog post, let us learn how I fixed Property Backu …

Insert Performance Limitations with Sequentially Increasing Index

Publié le 9 octobre 2016 sur sqlblog.com
 

Earlier this year, HPE and Microsoft sponsored an article, The Importance of Benchmarking , in SQL Server Pro. While true, it is also apparent that there has been little interest in benchmarks within the DBA/IT community over the last several years. Th …

What is a Backup Timeline for Restore Process? – Interview Question of the Week #092

Publié le 9 octobre 2016 sur journey to sqlauthority
 

Question: What is a Backup Timeline for Restore Process? Answer: One of the most popular interview question about Backup and Restore Database process. I find it very interesting that after so many years of this concept introduced, but after so many yea …

SQL SERVER – Unable to Start Services After Patching (sqlagent_msdb_upgrade.sql)

Publié le 8 octobre 2016 sur journey to sqlauthority
 

In the recent past, I have heard this issue, at least once or twice every month. Whenever I try to help a such client and I think I know the issue, I get something new. They said that they have applied a patch and after that they were not able to acces …

The Law Of The Minimum

Publié le 7 octobre 2016 sur brentozar.com
 

I like science fiction Not enough to go to conventions, or memorize every line, but I have some opinions on things. Dune is probably my favorite series of stories in the genre. Yes, I think Paul would beat Luke in a fight. Sorry, Star Wars people. …

How to generate T-SQL scripts in SQL Server Management Studio with the collation settings

Publié le 7 octobre 2016 sur sqlservercentral.com
 

SQL Server collation is an important setting when creating database objects. One of the best ways to ensure that collation issues do not happen is to ensure that the collation settings are properly specified in the script that generates the database ob …

SQL SERVER – Fix: The Cluster Resource Could not be Deleted Since it is a Core Resource

Publié le 7 octobre 2016 sur journey to sqlauthority
 

Working with SQL Server is fun. Since SQL Clustering, and AlwaysOn availability group needs Windows Clustering so sometimes there are some cluster issues which I have to deal with and fix. Let us learn about an error related to core resource. Recently, …

Representing Hierarchical Data for Mere Mortals

Publié le 6 octobre 2016 sur simple-talk.com
 

Following Along Getting Query Results from a Server in a Hierarchical Way Simple queries with metadata Queries that return XML columns Using SMO Saving Endpoint Configuration Settings Saving and Comparing Configuration Settings Getting the Quantities o …

Update On Connect Item To Replace DBCC SHOW_STATISTICS

Publié le 6 octobre 2016 sur brentozar.com
 

Wanna see other peoples’ bad queries? Check out the 20 most recent plans at PasteThePlan. ALL CAPS EXCITEMENT In rather fun news, a Connect Item of mine about replacing DBCC SHOW_STATISTICS with a DMV or function got updated as ‘Resolved as Fixed …

Taking Pictures from HTML

Publié le 6 octobre 2016 sur sqlservercentral.com
 

Sometimes a request from a user who doesn’t appreciate the limitations of the technology can jolt you into discovering that an application feature that was, until recently, difficult to achieve is suddenly relatively easy. Dino was asked to allow the u …


Pages :