Sites anglophones

PowerShell – Script to Listing all Backups Taken with SQL Server

Publié le 24 octobre 2016 sur journey to sqlauthority

I always like to keep a number of scripts handy in my USB drive with my Laptop. These scripts are used for my internal use when I am suddenly looking for something interesting in customer environments. One of the scripts that I use is shown below. Many …

The sniffing database

Publié le 23 octobre 2016 sur

Your SQL Server instances, like people with hay fever that forget to take their antihistamines during summer, is sniffing all the time. Sniffing is a trick employed by the optimizer in an attempt to give you better execution plans. The most common form …

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

Publié le 23 octobre 2016 sur

This week, Brent (and only Brent) answers your questions about table partitioning, best practices for VMware configuration, rebuilding indexes, transitioning from physical SQL failover cluster to VMware or Hyper-V, database backups, security issues wit …

Fastest Way to Display Code of Any Stored Procedure – Interview Question of the Week #094

Publié le 23 octobre 2016 sur journey to sqlauthority

A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they do not know the answer of this question, I would not …

PowerShell – Tip: How to Format PowerShell Script Output?

Publié le 22 octobre 2016 sur journey to sqlauthority

I have been writing on various ways of working with PowerShell and how to connect to SQL Server. Personally, when I see text on command prompt it is quite a mess and very difficult to decipher the same. If you play around and look at various blog posts …

SQL PASS 2016 Preview

Publié le 22 octobre 2016 sur

What’s happening at next week’s SQL PASS 2016 Summit What’s happening at this year’s SQL PASS 2016 conference read more

Thoughts About the #SQLSummit Day 1 Keynote

Publié le 21 octobre 2016 sur

Quentin Clark I’ll be honest, dear reader: I usually hate the holy hell out of the Summit day 1 keynote. As an example, check out the last keynote I liveblogged – go to the bottom and then read up. (Sorry, I won’t do that style again. …

How to Fix Ten SSDT Deployment Snags, With or Without ReadyRoll

Publié le 21 octobre 2016 sur

In this article, which follows on logically from one I wrote about Solving Visual Studio database delivery problems with ReadyRoll, I’ll be describing the ten most common SSDT database deployment problems that you’re likely to hit when doin …

Reading, Writing, and Creating SQL Server Extended Properties

Publié le 21 octobre 2016 sur

What I’d like to do in this article is to explain something about SQL Server extended properties, why they are so important, and illustrate some ways of working with them, scripting them, and maintaining them. Why Extended Properties? Before SQL …

SQL Server 2014 Build List

Publié le 21 octobre 2016 sur

A list of builds for SQL Server 2014, through CU9 for SP1.

Memory/Storage Technology Hierarchy and SQL Server

Publié le 21 octobre 2016 sur

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Dav …

PowerShell Scripts – get-process with SQL Server process

Publié le 21 octobre 2016 sur journey to sqlauthority

Working with powershell scripts can be interesting. I have in the past shown a number of such scripts that we can use with SQL Server. In this blog, I was playing around understanding how I can use the get-process commandlet and how it can be used with …

Post PASS Summit 2016 Resolutions – Followup

Publié le 21 octobre 2016 sur

Last year I started a new tradition for myself that will last until I specifically retire from the SQL Server community, something that I practically promise isn’t coming in next year’s resolutions. As this is the end of the PASS year, with the Summit …

Getting a history of database snapshot creation

Publié le 21 octobre 2016 sur - paul randall

Earlier today someone asked on the #sqlhelp Twitter alias if there is a history of database snapshot creation anywhere, apart from scouring the error logs. There isn’t, unfortunately, but you can dig around the transaction log of the master datab …

Agile or Waterfall?

Publié le 20 octobre 2016 sur

Waterfall project management is a serial approach to the phases of a project. Proponents of waterfall methodologies hold it’s best to plan: gather requirements, design the solution, develop it, test it, deploy and maintain it in discrete steps. C …

Pages :