Sites anglophones

Moving Databases with ALTER DATABASE

Publié le 1 mars 2016 sur

True story A long time ago, I had to actually do stuff to databases. One thing I had to do was move data files around. Maybe some knucklehead had put system databases on the C: drive, or a LUN was filling up, or we got a new LUN. You know, whatever. Na …

Exploring SQL Server 2016 Dynamic Data Masking – Part One

Publié le 1 mars 2016 sur

Greg Larson looks at how to hide the value of sensitive data by applying Dynamic Data Masking.

Stairway to SQLCLR Level 6: Development Tools Intro

Publié le 1 mars 2016 sur

This time we look at the commonly used tools for doing SQLCLR development: Visual Studio (VS), SQL Server Data Tools (SSDT), and SQL Server Express LocalDB (LocalDB).

SQL SERVER – Instance Definition Working with Oracle and SQL Server

Publié le 1 mars 2016 sur journey to sqlauthority

During various conferences and user group Meetups I meet tons of new people who keep asking me on a number of topics that can sometimes be challenging for me. In a recent SQL Server Bangalore User Group chapter that I just bumped into an individual who …

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

Publié le 1 mars 2016 sur

A Review of Part 1 In part one of this article I laid out the base query for which to return valuable information out of the sys.dm_db_index_usage_stats Dynamic Management View.  In part two here I’ll now so how we can use the base query for …

[Video] Free Training of the Week: Advanced Storage Features – Tiering

Publié le 29 février 2016 sur

In this week’s free video training sample, we talk about tiering. Automated storage tiering is an advanced SAN feature that can automatically put the most active data on the fastest drives. Here’s how it works and how it affects SQL Se …

Possible #powerpivot issue removing Excel 2016 going back to Excel 2013

Publié le 29 février 2016 sur

Today I observed an issue on a notebook where Excel 2016 was installed and then removed, going back to Excel 2013. After this operation, workbooks having a Power Pivot data model were working correctly by navigating data in PivotTables, but a …

Data Mining Part 36: Verifying the accuracy of the model

Publié le 29 février 2016 sur

In this new chapter we will show how to verify the accuracy of the mining models.

SQL SERVER – Unable to start SQL Server Agent – Failed to initialize SQL Agent log

Publié le 29 février 2016 sur journey to sqlauthority

My friend was researching with SQL Agent parameters and after sometime he called me and told that he is not able to start SQL Agent service. Here was the error in SSMS Text is below: TITLE: Microsoft SQL Server Management Studio ——— …

Interview Question of the Week #060 – What is the Difference Between EXCEPT and NOT IN?

Publié le 28 février 2016 sur journey to sqlauthority

Earlier this week, I had the opportunity to take many different interviews. Most of the DBA and Developers update their resume with various versions of the SQL Server. It seems like everybody had written SQL Server 2005 as one of their expertise. At th …

SQL SERVER – AlwaysOn Availability Group Stuck in Resolving State For Longtime

Publié le 27 février 2016 sur journey to sqlauthority

This is one of the common issues which I heard from my clients using SQL Server and they don’t know why it happens. What is resolving state? When there is an availability group, the replica would be either in primary state or secondary state …

Out of Office: Time For the 2016 Brent Ozar Unlimited Retreat

Publié le 26 février 2016 sur

Last year’s company retreat on the Oregon coast Thank you for your web visit. Your eyeballs are very important to us. However, we’re out of the office and will be back on Monday, March 7, 2016. During this period we will have limited a …

[Video] Office Hours 2016/02/25

Publié le 26 février 2016 sur

In this week’s Office Hours Q&A, Doug, Erik, Jessica, and Richie discuss developer security on development servers, when application roles make sense, where to find information about deadlocks, and the fact that many (most?) of the folks who …

Public Data Sets

Publié le 26 février 2016 sur

A list of data sets you can download and play with for practice, demos, or your own analysis.

Database Design Follies: NULL vs. NOT NULL

Publié le 26 février 2016 sur

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems …

Pages :