Sites anglophones


24 Hours of PASS (July 2017) – Summit Preview

Publié le 25 juin 2017 sur sqlblog.com
 

Which topics can you expect to see at the PASS Summit 2017 ? Find it out from July 19 to 20, 2017 at the 24 Hours of PASS Summit Preview edition.Register now at this link, thanks to the Sponsors, the 24 Hours of PASS is presented at no cost for yo …

Cosmos DB References

Publié le 24 juin 2017 sur sqlblog.com
 

Here is a list of links to get you started in understanding Cosmos DB, Microsoft’s new cloud based globally distributed multi-model database. Cosmos DB development started in 2010 as project Florence. When it was initially released to the public …

Does Separating Data and Log Files Make Your Server More Reliable?

Publié le 24 juin 2017 sur brentozar.com
 

The old advice went something like this: “Put your data and log files on separate drives and your server will be more reliable. If you lose the data drive, you can still do a tail-of-the-log backup, and you won’t lose any data.” It …

SQL SERVER – Error: Timeout (30000 milliseconds) Waiting for the SQL Server (MSSQLSERVER) Service to Connect

Publié le 24 juin 2017 sur journey to sqlauthority
 

I have been dealing with a client who observed that SQL services not starting up after a server reboot. When I asked them to check event logs, they found below timeout error. Event Type: Error Event Source: Service Control Manager Event Category: None …

How to calculate barcode check-digit using T-SQL language

Publié le 23 juin 2017 sur sqlblog.com
 

IntroductionIn order to scale, it’s imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to customers efficiently? The answer is: Barcode! A barcode is the graphical representation of a sequence …

Is It Time To Stop Using IsNumeric()?

Publié le 23 juin 2017 sur simple-talk.com
 

IsNumeric(), the unloved system function. The system function IsNumeric() is so unloved that I feel compelled to say something in its’ defence. It is more or less giving you the correct answer, but to a different question to the one that you …

Trainable SQL Servers

Publié le 23 juin 2017 sur brentozar.com
 

Funny thing The human body is pretty good at adaptation. When you get sick or injured, your body responds and (most of the time) heals itself up. When you stress your body in a certain way, over time, your body will feel less stressed by the same level …

Getting Started with Azure SQL Data Warehouse – Part 5

Publié le 23 juin 2017 sur sqlservercentral.com
 

In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali looks at performance optimization.

Where’s the Ops in DevOps? Part 1

Publié le 23 juin 2017 sur sqlservercentral.com
 

In the first of a three-part series, guest bloggers from DevOpsGuys look at the real role of Ops in DevOps. Where it changes, how it changes, and why Ops has an important part to play in the brave new world of DevOps.

Microsoft SQL Server Utilities and Tools

Publié le 23 juin 2017 sur sqlservercentral.com
 

Useful free and paid utilities and tools for Microsoft SQL Server – complete list of 213 Utilities

SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored Because it was Created by a Different Version of the Server

Publié le 23 juin 2017 sur journey to sqlauthority
 

In the recent past, I have written a blog about Ransomware. Here is the link. SQL SERVER – How to Protect Your Database from Ransomware?. In this blog post we are going to discuss about system database. One of my client was hit with Ransomwa …

Cosmos DB Podcast While You Commute

Publié le 23 juin 2017 sur sqlblog.com
 

Cosmos DB is Microsoft’s new Azure (i.e. Microsoft cloud) globally distributed multimodel database. There is a good podcast where Rimma Nehme explains it. I’ve also wanted to blog about how to configure USB flash drives to play mp3 files on …

24 Hours of PASS: Last Season’s Performance Tuning Techniques

Publié le 22 juin 2017 sur brentozar.com
 

Brent, last season (and I have so many good bad photos to share) I’m excited to announce that Erik and I are presenting the opening session at this year’s free online 24 Hours of PASS webcasts! Here’s our session: Last Season’s …

Seldom Used Keyboard Tricks

Publié le 22 juin 2017 sur sqlblog.com
 

  I was giving an internal talk on SSMS productivity trips and there were a few that I believe are seldom used but can be a real time or keystroke saver that I would like to mention. To the best of my knowledge these will work in any version of SS …

Builder Day: Cloudbuilding Episode 1 – The Road to HANA

Publié le 22 juin 2017 sur brentozar.com
 

Staving off obsoletion Brent has recently set aside “free” time to learn about stuff up in the cloud. I only put free in quotes because we do have to do something with a cloud theme, but we can pick whatever we want. Naturally, I chose the …


Pages :