Sites anglophones

Tuning Dynamic SQL by Hand with Short Circuits

Publié le 23 janvier 2019 sur

When we think about building dynamic SQL, we usually think about a stored procedure like this that takes input parameters, builds a string, and then executes that string. Here’s a simple example:CREATE OR ALTER PROC dbo.usp_SearchUsers @SearchDis …

New Fundamentals of Index Tuning Course

Publié le 23 janvier 2019 sur

You’re a developer who needs to make your application go faster, and you don’t want to (or can’t!) change the queries. You’ve never been to an official training class, and your manager isn’t about to spring for travel. In …

SQL Server Reporting Services Report Builder with DAX Query Support

Publié le 23 janvier 2019 sur

In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.

SQL SERVER – Identify Datatype Using SQL_VARIANT_PROPERTY Function

Publié le 23 janvier 2019 sur journey to sqlauthority

One of my client of Comprehensive Database Performance Health Check sent me the following email about SQL_VARIANT_PROPERTY Function. I really love my job as SQL Server consultant as I get to learn most of the new stuff or discover the hidden knowl …

Free Downloads for Powerful SQL Server Management

Publié le 22 janvier 2019 sur

You’re responsible for managing and troubleshooting SQL Server. Good news: you’re not alone. The SQL Server community has banded together and built a bunch of cool stuff to help you do your job easier. In a one-hour session this morning for …

Creating and using inline table-valued functions

Publié le 22 janvier 2019 sur

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000. iTVFs remain a very useful tool in our SQL armoury, so let’s quickly revisit them and the different ways we …

Customizing the Default Azure Data Studio Dashboards

Publié le 22 janvier 2019 sur

Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.

SharePlex – Efficient and High Performance Replication from Oracle to Kafka

Publié le 22 janvier 2019 sur journey to sqlauthority

Ask any DBA what is their dream infrastructure and I promise you that they will narrate immediately a story which will be centered around no downtime and amazing performance. However, when you ask them if they know what exactly will make them …

The BI Journey: The Analyst

Publié le 21 janvier 2019 sur

AdventureWorks, the famous bicycle and accessories seller, has hired a new intern who joined the North American regional sales department. Ruthie, who is studying for a degree in IT, landed the internship to work for the Sales Manager Stephen as an ana …

Implementing DevOps Doesn’t Get Rid of Database Administrators

Publié le 21 janvier 2019 sur

I hear from a lot of database administrators who are worried about being automated out of a job. These kinds of worries are not new. Over the course of my career, I’ve seen CTOs outsource large groups of IT jobs to different regions around the wo …

Which Version of SQL Server Should You Use?

Publié le 21 janvier 2019 sur

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version? I know, management wants you to stay on an older build, and the vendor says they’ll only support older versions, but now’s your chanc …

The 4 capabilities you need to introduce true database DevOps

Publié le 21 janvier 2019 sur

The latest Accelerate State of DevOps Report from DORA concludes that successful software delivery unlocks competitive advantages, including “increased profitability, productivity, market share, customer satisfaction and the ability to achieve or …

SQL SERVER – FCB::Open Failed – TEMPDB Files Fail to be Created with Error: “CREATE FILE Encountered Operating System Error 3”

Publié le 21 janvier 2019 sur journey to sqlauthority

Once there was an urgent request from my client and they asked my assistance. Without wasting any time, I sent them GoToMeeting invite and started working. In this blog we would learn how to fix FCB:: Open failed for TempDB database. As soon as I joine …

Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209

Publié le 20 janvier 2019 sur journey to sqlauthority

Question: Does NOLOCK Really Applies No Lock? Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct. Sch-S or Schema Stabil …

SQL Server Data Migration: Tools and Services

Publié le 19 janvier 2019 sur

The Database Migration Team of the SQL Server Product Group has created the following tools and services to facilitate migration between different versions of SQL Server or between on-premises and SQL Azure DB in the cloud (but not only)! Azure Da …

Pages :