Sites anglophones

SQL SERVER – What Does WHERE 1=1 Mean in the Code?

Publié le 1 octobre 2015 sur journey to sqlauthority

One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?” Well. You have seen people using it when they dynamically construct WHERE condition based on the input values. Let us create …

SQL Server 2016 CTP2.4: Maintenance Plan Changes

Publié le 30 septembre 2015 sur

You can download the next preview of SQL Server 2016 today, and the announcement blog post touted a few improvements to maintenance plans. Oddly, the screenshots in the announcement were apparently done with Microsoft Paint, so I fired up a VM to …

Forgotten Maintenance – Cycling the SQL Server Error Log

Publié le 30 septembre 2015 sur

Most of us get caught up in fragmentation, finding the slowest queries, and looking at new features. We forget the little things that make managing a SQL Server easier – like cylcing the SQL Server error logs. What’s the Error Log? The SQL …

Synoptic Panel for Power BI Best Visual Contest #powerbi #contest

Publié le 30 septembre 2015 sur

Today (September 30, 2015) is the last day to submit an entry in the Power BI Best Visual contest. I and Daniele Perilli (who has the skills to design and implement UI) spent hours thinking about something that would have been challenging and useful at …

Stairway to MDX – Level 15: Basic Set Functions: The Tail() Function

Publié le 30 septembre 2015 sur

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.

Install SQL Server Management Studio with Web Installer without Internet Access

Publié le 30 septembre 2015 sur

One of the new features of SQL Server 2016 is the introduction of a Web Installer for the client tools. In this article, Daniel Farina goes through the entire process of downloading and installing the client tools even on machines without internet acce …

SQL SERVER – What is Windows Internal Database Edition?

Publié le 30 septembre 2015 sur journey to sqlauthority

The more you read the more you learn. But some of the best learnings need not come from known sources. These can be accidental too. These learnings in my opinion involves tons of exploration which you would have never done before. This blog post today …

Introducing SQL Server In-Memory OLTP

Publié le 30 septembre 2015 sur

In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload, it then had certain restrictions that impeded its widespread adoption.With SQL Server 2016,  there is more su …

Checklists: A DBA’s Best Friend

Publié le 30 septembre 2015 sur

Because so much of the work of the DBA involved doing things in the right order without missing steps out, checklists are a great way of ensuring that the chance of mistakes is minimised. DBAs generally create the sort of checklist style that suits the …

Data Breaches and Insider Threats

Publié le 29 septembre 2015 sur

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security …

Building a Desktop Workstation for SQL Server Development and Testing

Publié le 29 septembre 2015 sur - glen berry

Back in March of 2014, I wrote a fairly long blog post called Building a Workstation for SQL Server 2014 Development and Testing, which still generates quite a bit of hits and e-mail. Since it is about eighteen months later, I thought it was about time …

Identifying High-Impact Queries and Stored Procedures with Dynamic Management Views

Publié le 29 septembre 2015 sur

Are you looking for a comprehensive set of scripts to identify queries or stored procedures with highest reads or writes, most CPU consumption, or are the longest running on your SQL Server instances? Then go no further than here where Tim Ford, who tr …

Window Functions and Cruel Defaults

Publié le 29 septembre 2015 sur

My First Post Here… Well, my first technical post, was about how the default index creation method is OFFLINE. If you want that sweet, sweet Enterpri$e Edition ONLINE goodness, you need to specify it. It’s been a while since that one; almo …

Build Your Own Resource Monitor in a Jiffy

Publié le 29 septembre 2015 sur

Wildcard Searches

Publié le 29 septembre 2015 sur

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.

Pages :