Sites anglophones

Live Blogging: Erik vs. PowerShell

Publié le 29 juillet 2017 sur

Oh, hey, happy Saturday First, I’d like to apologize to Conor Cunningham for the blatant theft of a blog title. That’s what you get for not posting in three years (like the desert miss the rain~). Why am I here? Why am I writing PowerShell, …

SQL SERVER – How to Check if a Column Exists in SQL Server Table?

Publié le 29 juillet 2017 sur journey to sqlauthority

Question: How to check if a column exists in SQL Server table? Answer: A fantastic question honestly. Here is a very simple answer for the question. Option 1: Using Col_Length I am using the following script for AdventureWorks database. IF COL_LENGTH(‘ …

Data in Motion and Data at Rest

Publié le 28 juillet 2017 sur

Understanding data flow In the 1970s, programming changed completely. This radical change was later called the “Structured Revolution” and it began with a famous article by Edsger Dijkstra. (Dijkstra, Edsger W. A Case against the GO TO Stat …

SQL Server 2017: Less xp_cmdshell?

Publié le 28 juillet 2017 sur

Pokin’ SQL Server 2017 RC1 dropping recently reminded me of a couple things I wanted to blog about finding in there. One that I thought was rather interesting is a new iTVF called dm_os_enumerate_filesystem. It looks like a partial replacement fo …

Simple Talk is hiring a full-time editor

Publié le 28 juillet 2017 sur

Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They’re open to accepting remote workers, so if you’re interested, there’s no excuse not to go ahead and apply!

Getting Started with SQL Server 2012 Express LocalDB

Publié le 28 juillet 2017 sur

Developers using SQL Server Express face a few challenges in their day to day work. One is that setting up and maintaining Express can be a daunting task.

SQL SERVER – How to Identify Columns Used In A View?

Publié le 28 juillet 2017 sur journey to sqlauthority

The views are very tricky. Sometimes they help performance and sometimes they negatively impact performance. Recently, during Comprehensive Database Performance Health Check, I realized that one of the view was the real performance killer. The cha …

New course: Upgrading and Migrating to SQL Server 2016

Publié le 27 juillet 2017 sur - paul randall

We’ve just published a new Pluralsight course! This is Glenn’s latest course – SQL Server: Upgrading and Migrating to SQL Server 2016 – and is just over two hours long. It’s a must for anyone working on a pr …

Upgrading to SQL Server 2016

Publié le 27 juillet 2017 sur - glen berry

Many organizations are running older and possibly out of support versions of SQL Server, running on older versions of Windows Server, on old, slower, out of warranty hardware and storage. SQL Server 2005 fell out of extended support on April 12, 2016. …

ColumnStore Indexes And Recursive CTEs

Publié le 27 juillet 2017 sur

Alone Together When I think about SQL Server features, I often picture a high school cafeteria. AGs are making fun of Mirroring, index rebuilds are walking around taking everyone’s lunch, dta is making a glue sandwich, and no one knows who Servic …

Other People’s Blog Posts I Talk About the Most

Publié le 27 juillet 2017 sur

In my work with clients and classes, some blog posts come up a LOT. Forcing a Parallel Query Execution Plan by Paul White – Paul’s posts usually cover execution plan components in incredible detail, but the real gem in this one is the secti …

Advanced Analytics with R and SQL Part II – Data Science Scenarios

Publié le 27 juillet 2017 sur

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.

SQL SERVER – FIX: RequireKerberos Error During SQL 2008 Installation on Windows 2008 R2 Cluster

Publié le 27 juillet 2017 sur journey to sqlauthority

Today the progress made in technology is astounding and beyond our imaginations, but still there are clients who can’t move to higher, latest and greatest version of SQL so easily. They are still stuck with SQL 2005 and SQL 2008 SQL servers. In t …

Looking for sp_whoisactive?

Publié le 26 juillet 2017 sur

A while ago I quietly announced the new home for sp_whoisactive, . Today I finished migrating all related content — including the documentation consisting of a series of 28 articles posted on this blog a while back. So if you’re lookin …

SQL-On-Hadoop: Hive – Part I

Publié le 26 juillet 2017 sur

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.

Pages :