Sites anglophones

HPE Superdome X FAQs

Publié le 19 mai 2016 sur

The HPE Superdome offers several unique features, and here are some FAQs to help you get the most out of them. read more

Learn More with Penton Technology’s New Professional Education Platform

Publié le 19 mai 2016 sur

We’re proud to share our new  Penton Technology Professional Education platform, which will enrich the online education experience for IT professionals. “Our new education platform allows tech professionals to enhance their career …

What to Do When DBCC CHECKDB Reports Corruption

Publié le 19 mai 2016 sur

The instant you encounter corruption in a production SQL Server database, here’s what to do: 1. Query the msdb.dbo.suspect_pages table. This system table tracks up to the last 1,000 corrupt pages detected. This will give you a quick idea of how w …

Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)

Publié le 19 mai 2016 sur

How can Redgate DLM help you improve your database development and deployment processes? Join Grant Fritchey to see a demo of the Redgate DLM tools working with TFS, TeamCity, and Octopus Deploy. You’ll learn how to version control your databases, incl …

A Comparison of JDBC Drivers for MySQL

Publié le 19 mai 2016 sur

A brief comparison of three different JDBC Drivers built for connecting with MySQL

Comparing Networking Options in Azure

Publié le 19 mai 2016 sur

What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you’ll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), …

SQL SERVER – Handling XML Documents – Notes from the Field #125

Publié le 19 mai 2016 sur journey to sqlauthority

[Note from Pinal]: This is a 125th episode of Notes from the Field series. Handing XML documents is not an easy task. Trust me till today I see lots of experts struggling when they have to deal with XML. In my early career I used to be scared with the …

Extended Events: Where They Hide The Good Stuff

Publié le 18 mai 2016 sur

You can do a lot with Extended Events I’m really looking forward to the stuff in 2016 becoming mainstream in 2020 or so. Raise your hand if you’re using SQL Server 2014 in production. Raise your hand if your vendor supports SQL Server 2014. …

SQL Server 2012 Build List

Publié le 18 mai 2016 sur

A list of the builds of SQL Server 2012 through SP2 CU11.

Differences between Delete and Truncate in SQL Server

Publié le 18 mai 2016 sur

Atul Gaikwad details the differences between DELETE and TRUNCATE, including how they vary in terms of being rolled back.

Stairway to Database Source Control Level 5: Working with Others (Distributed Repository)

Publié le 18 mai 2016 sur

This level starts with an overview of how versioning works in Git, a DVCS, and suggests a sensible database project versioning strategy. It then offers some simple, but illustrative, practical examples showing how to share database changes and deal gra …

24 Hours of PASS – Evolution of the Data Platform – The Grand Finale

Publié le 18 mai 2016 sur

I am honored that I was selected to present my session « Winning with Column Store: A Customer Story » for the upcoming 24 Hours of PASS event. Details about my session and the 23 other sessions may be found here – …

SQL SERVER 2016 – Management Studio Highlighting Current Line Option

Publié le 18 mai 2016 sur journey to sqlauthority

With every new release, there is changes that are being made to the tools that support it. It is tough sometimes to keep up with the pace. I am always an old school guy and I try not to change the style that involves changes to the way things function. …

Data Tales #8: Database on a Diet (Part 3)

Publié le 18 mai 2016 sur

Hi Folks, My series of articles for SQL Server Magazine continues. Last time, I continued a short series about a large database that needed to go on a diet. Last time, I look at the internals of row and page compression, to see what happens when they a …

Predictive Analysis Basics

Publié le 18 mai 2016 sur

Statistics holds out the promise of teasing out significant relationships and to determine cause and effect. Now that so much data is easily available, does that mean that we can at last harness these techniques to predict future trends and outcomes? F …

Pages :