Sites anglophones


Stairway to Exploring Database Metadata Level 3: Exploring Indexes

Publié le 28 septembre 2016 sur sqlservercentral.com
 

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.

SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality

Publié le 28 septembre 2016 sur journey to sqlauthority
 

I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose. So let me …

SQLintersection Fall 2016

Publié le 27 septembre 2016 sur sqlskills.com - paul randall
 

As we head into our 8th SQLintersection next month, I’m excited to say that it’s our most diverse, complete, and information-packed show yet! We have 3 precon days at the show and with our postcon day, there are 10  …

What To Do If sp_BlitzFirst Warns About High Compilations

Publié le 27 septembre 2016 sur brentozar.com
 

Compiles Aren’t The Same As Recompiles If you’re seeing high RECOMPILES, this post isn’t for you. We’ll talk about the differences between compiles and recompiles, but not how to troubleshoot recompiles. Recompiles mean one of t …

PowerShell Solutions – Several tips for daily tasks

Publié le 27 septembre 2016 sur sqlservercentral.com
 

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.

PowerShell Desired State Configuration: DSC Resources

Publié le 27 septembre 2016 sur sqlservercentral.com
 

Desired State Configuration (DSC) allows you to automate the way that you manage configuration data for software services as well as the environment in which these services run. DSC uses a set of built-in and custom ‘resources’ as the building blocks f …

SQL SERVER – How to Find Out When Your SQL Login Will Expire?

Publié le 27 septembre 2016 sur journey to sqlauthority
 

If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Login.  It was an easy task. I went to books …

PASS Summit – Free Thursday NIght

Publié le 26 septembre 2016 sur sqlblog.com
 

It was recently pointed out that there is no official event scheduled for Thursday night the week of the PASS Summit this year. I am fine with that. By the time Thursday rolls around, I might want to use that time to catch up on sleep. 🙂 Seriously, t …

SQL Server 2012 Cumulative Updates (September 2016)

Publié le 26 septembre 2016 sur sqlblog.com
 

Microsoft has released the following Cumulative Updates for SQL Server 2012 (SP2 and SP3).Cumulative Update 14 for SQL Server 2012 SP2KB 3180914DownloadBuild number: 11.0.5657.0 SQL Release Services Blog postCumulative Update 5 for SQL Server …

What Every Accidental DBA Needs to Know Now: SQL Server Configuration Manger

Publié le 26 septembre 2016 sur sqlmag.com
 

The SQL Server Configuration Manager is an critical but often overlooked application for proper SQL Server instance management and, well, « configuration ». In Tim Ford’s continuing series aimed at the Accidental Database Administrator he takes time to e …

[Video] Office Hours 2016/09/21 (With Transcriptions)

Publié le 26 septembre 2016 sur brentozar.com
 

This week, Brent, Richie, Tara, and Erik discuss enhancing queries, database corruption, availability groups, parameter sniffing, sending mail via SQL server, whether SQL 2016 is solid or not, other versions of SQL, physical servers vs virtual servers, …

Expanding the uses of DBCC CLONEDATABASE

Publié le 26 septembre 2016 sur sqlservercentral.com
 

Erin Stellato goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE.

Bones of SQL – Grouping By User-Defined Calendar Periods

Publié le 26 septembre 2016 sur sqlservercentral.com
 

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.

SQL SERVER – Patch Installation Error: The version of SQL Server instance does not match the version

Publié le 26 septembre 2016 sur journey to sqlauthority
 

Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error. The version of SQL Server instance <InstanceName> does not match the versio …

Big Data V’s

Publié le 25 septembre 2016 sur sqlblog.com
 

Originally there were three V’s of Big Data. Doug Laney introduced Volume, Velocity, and Variety as the three V’s of data management in 2001 when he worked for the Meta Group, which was purchased by Gartner in 2005 . He did not use the term …


Pages :