News in the Category: SQL Subscribe to the rss of this category.

Total posts: 7676 | Sort by Views | Sort by Hits

SQL SERVER How to Find Out When Your SQL Login Will Expire?

Journey to SQL Authority with Pinal Dave, September 27, 2016
Views: 42 | Hits 1

If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Log...

SQL SERVER Patch Installation Error: The version of SQL Server instance does not match the version

Journey to SQL Authority with Pinal Dave, September 26, 2016
Views: 67 | Hits

Applying a patch is something which is part of everyones life in the software industry. One of my clients reported below error related to Patch Installation Error. First appeared on SQL SERVER – Patch...

Identify Used Space in Log File- Interview Question of the Week #090

Journey to SQL Authority with Pinal Dave, September 25, 2016
Views: 91 | Hits 2

Question: How to identify Used Space in Log File?Answer: Use following command to display used log file size and total used space in the log file.First appeared on Identify Used Space in Log File- Int...

PowerShell Reading Tables Data Using Script

Journey to SQL Authority with Pinal Dave, September 24, 2016
Views: 93 | Hits 1

Earlier in this blog, I have written a number of posts by using PowerShell. The more you play around with this scripting language more are the hidden gems that come out. Personally for me, everyday is...

SQL Simple Utilities

The Code Project Latest Articles, September 23, 2016
Views: 112 | Hits 6

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records....

SQL SERVER How to Join a Table Valued Function with a Database Table

Journey to SQL Authority with Pinal Dave, September 23, 2016
Views: 100 | Hits 2

Just another day I received following question and I find it very interesting. I decided to try it out on SQL Server 2016's new WideWorldImporters database. The question was - "How to Join a Table Va...

SQL SERVER Set AUTO_CLOSE Database Option to OFF for Better Performance

Journey to SQL Authority with Pinal Dave, September 22, 2016
Views: 111 | Hits 4

As many of you know, I am an indecent SQL Server Consultant, who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently...

SQL SERVER How to Hide Number of Rows Affected Message? SET NOCOUNT

Journey to SQL Authority with Pinal Dave, September 21, 2016
Views: 106 | Hits 2

This blog post be ideally titled as back to basics as it is going to talk about one of the very old topics of SQL Server. Though this may look very simple for many, this blog post conveys the message ...

SQL Server Geeks Annual Conference

Simple Talk, September 20, 2016
Views: 85 | Hits 1

A couple of weeks ago I was privileged to be able to travel out to Bengaluru in India to attend the annual SQL Server Geeks Conference. It was my first time at the event and my first time in India. Wh...

More Power BI to your Elbow

Simple Talk, September 20, 2016
Views: 91 | Hits 4

Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier to get from the data to the visualisation as quickly as possible. You can ...

SQL SERVER Puzzle Change in Date Format with Function

Journey to SQL Authority with Pinal Dave, September 20, 2016
Views: 93 | Hits 2

Last week we had amazing time with an interesting puzzle about Datetime. You can see the puzzle over here. The puzzle was extremely well received and lots of people asked me to bring another puzzle wh...

SQL SERVER How to INSERT or SELECT Copyright Special Characters in SSMS?

Journey to SQL Authority with Pinal Dave, September 19, 2016
Views: 94 | Hits 3

I answer every email I receive in six hours and that is why sometimes I end up working over 18 hours in a day. However, sometimes I receive emails such that makes me wonder, how come I do not know som...

How to Find Missing SQL Server Configuration Manager? Interview Question of the Week #089

Journey to SQL Authority with Pinal Dave, September 18, 2016
Views: 111 | Hits

Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?First appeared on How to Find Missing SQL Server Configurat...

SQL SERVER -2016 Wait Stats and Queues Script Updated Identify Resource Bottlenecks

Journey to SQL Authority with Pinal Dave, September 17, 2016
Views: 126 | Hits 3

NOTE: This script will just work fine with earlier version of SQL Server (2008, 2012, 2014) along with SQL Server 2016. It will give the expected results in all the SQL Server versions. This script wi...

Power BI for Data Modelling

Simple Talk, September 16, 2016
Views: 129 | Hits 7

Power BI has a lot of uses, but one of the most interesting of them is to model and shape data to make it easier for self-service BI. Power BI is a full-stack solution that includes data loading, da...

How to Start Big Data with Apache Spark.

Simple Talk, September 16, 2016
Views: 150 | Hits 4

It is worth getting familiar with Apache Spark because it a fast and general engine for large-scale data processing and you can use you existing SQL skills to get going with analysis of the type and v...

Azure SQL Data Warehouse: Explaining the Architecture Through System Views

Simple Talk, September 16, 2016
Views: 129 | Hits 5

The architecture of Azure SQL Data Warehouse isn't easy to explain briefly, but if you have some useful queries that access the management and catalog views, and diagrams that show how they relate ...

SQL SERVER Case of Different Default Collation on Two Servers

Journey to SQL Authority with Pinal Dave, September 16, 2016
Views: 134 | Hits 4

Along with long term performance tuning engagement, I also provide quick consult (On Demand) to assist with any short-term issue, which might get fixed by talking to an expert. Some of the questions a...

SQL SERVER Puzzle Playing with Datetime with Customer Data

Journey to SQL Authority with Pinal Dave, September 15, 2016
Views: 137 | Hits 4

I am preparing for a professional tour of Europe wherein I am planning to meet a number of customers as part of consulting and performance tuning assignments that I have agreed in early October. I am ...

SQL SERVER How to Downgrade SQL Server Edition?

Journey to SQL Authority with Pinal Dave, September 14, 2016
Views: 115 | Hits 2

One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. In thi...

SQL SERVER Columnstore Index Cannot be Created When Computed Columns Exist

Journey to SQL Authority with Pinal Dave, September 13, 2016
Views: 118 | Hits 1

Explorations working with SQL Server never stop and I get an opportunity to learn something every other day. Today I thought of bringing pout some learning that happened to me by accident. As I was no...

Bringing Control Back to Database Deployment with ReadyRoll and Entity Framework Code First Migrations

The Code Project Latest Articles, September 12, 2016
Views: 96 | Hits 2

In this article, Im going to show you how you can continue using EF Code First to model your database, while also using ReadyRoll to do the actual deployment of T-SQL change scripts and overcome the c...

MySQL Fix Error WordPress Database Error Duplicate Entry for key PRIMARY for Query INSERT INTO wp_options

Journey to SQL Authority with Pinal Dave, September 12, 2016
Views: 91 | Hits

As many of you know that this blog runs on Wordpress and under the hood of Wordpress there is a MySQL database. MySQL database is quite good and is able to hold massive traffic this blog receives ever...

How to Hide Stored Procedures Code? WITH ENCRYPTION Interview Question of the Week #087

Journey to SQL Authority with Pinal Dave, September 11, 2016
Views: 107 | Hits 4

Question: How to Hide Stored Procedure's Code so anyone with access to stored procedure cannot see it?First appeared on How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of t...

SQL SERVER Setup Screen Not Launching While Updating a Patch

Journey to SQL Authority with Pinal Dave, September 10, 2016
Views: 133 | Hits

This is one of the client contacts where I realized the importance of looking at right log file. The client said that he double clicks the.exe, a window flash by and disappears. It looked like somethi...

SQL SERVER How to Increase the SSMS Grid Font Size?

Journey to SQL Authority with Pinal Dave, September 9, 2016
Views: 137 | Hits 3

SQL Server Management Studio (SSMS) is part of SQL DBAs life. I use it while doing the presentation. If you are sitting in a big room like below, then the guy sitting in the last row may not be able t...

SQL Sentry Plan Explorer Release Now Completely Free For All Users

Journey to SQL Authority with Pinal Dave, September 8, 2016
Views: 135 | Hits 5

Earlier today SQL Sentry CEO Greg Gonzalez announced the completely free release of Plan Explorer, with two groundbreaking new features: Index Analysis and Performance Profiling. A vital component of ...

SQL Database: How to Configure Active Geo-Replication

Simple Talk, September 8, 2016
Views: 124 | Hits 3

Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the valu...

SQL SERVER FIX Error 18456, Severity: 14, State: 5. Login failed for user

Journey to SQL Authority with Pinal Dave, September 8, 2016
Views: 136 | Hits 1

Some errors are historic and have the most common root cause. Sometimes we really dont know why they happen and I have seen clients go nuts to identify the real reason for the problem. In a recent ema...

Master Data Services- The Basics

Simple Talk, September 7, 2016
Views: 129 | Hits 5

Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained, gives organisations a powerful alternative to increasingly...

SQL SERVER Database Backup and Restore Job Management

Journey to SQL Authority with Pinal Dave, September 7, 2016
Views: 138 | Hits 1

ApexSQL Backup is a tool for Microsoft SQL Server, intended for database backup and restore job management. The application supports all native SQL Server backups (full, differential and transaction l...

Consultants Life 30 Minutes Pre Call With Customer for SQL Server Performance Tuning?

Journey to SQL Authority with Pinal Dave, September 6, 2016
Views: 143 | Hits 5

Since I took the consulting way for about a year now, it is interesting to see that the fundamentals and basics of engaging with my customers have not changed for decades. I get a number of requests e...

In-Memory OLTP: Row Visibility in SQL Servers MVCC

Simple Talk, September 5, 2016
Views: 106 | Hits 1

SQL Server's In-memory OLTP is fast, due to its multi-valued concurrency control (MVCC). MVCC avoids the need for locks by arranging for each user connected to the database to see a snapshot of the r...

DELETE operation in SQL Server HEAPs

Simple Talk, September 5, 2016
Views: 111 | Hits 1

You should stick to using tables in SQL Server, rather than heaps that have no clustered index, unless you have well-considered reasons to choose heaps. However, there are uses for heaps in special ci...

SQL SERVER Understanding How to Play With Row Constructor

Journey to SQL Authority with Pinal Dave, September 5, 2016
Views: 138 | Hits 5

Every version of SQL Server brings in something new that challenges our understanding of how the software product works. For me, working with SQL Server is quite refreshing and fulfilling because ever...

How to Find Recent Executed Queries in SQL Server? Interview Question of the Week #086

Journey to SQL Authority with Pinal Dave, September 4, 2016
Views: 152 | Hits 8

Interviews are fun. Most of the time the interviewer has all the interesting questions, but I often come across a few individuals who stomps the interviewer. I was recently called by one of the organi...

SQL SERVER SSMS Enhancement Databases Node Filter Capability

Journey to SQL Authority with Pinal Dave, September 3, 2016
Views: 133 | Hits 1

I have been playing around with SQL Server 2016 for a while now and it is interesting how some of the things have changed drastically with this release. One of the key things I felt was the ability to...

SQL SERVER Find Week of the Year Using DatePart Function

Journey to SQL Authority with Pinal Dave, September 2, 2016
Views: 157 | Hits 1

As I blog every single day, lots of people ask me if I have to build a calender for the same. The answer is yes, I do not have a personal calender and I keep a note of all the ideas in the calender. T...

SQL SERVER Delete All Waiting Workflows in MSCRM to Speed Up Microsoft Dynamics

Journey to SQL Authority with Pinal Dave, September 1, 2016
Views: 172 | Hits 1

Last week, during performance tuning consultancy, I faced a very interesting situation when customer's Microsoft Dynamics CRM was extremely slow. After quickly researched we found that they have a ver...

The SQL of Textonyms

Simple Talk, August 31, 2016
Views: 525 | Hits 4

The task of finding textonyms in SQL involves importing a list of common words and doing transformations on every word to convert it into what you'd need to type into the numeric keypad of your mobile...

SQL SERVER Database Disaster Recovery Process

Journey to SQL Authority with Pinal Dave, August 31, 2016
Views: 141 | Hits 3

Many SQL Server DBAs are from time to time confronted with a disaster caused by unintentional or malicious changes on their database. Whatever the nature or intention of these changes are, they can ca...

Why is Uninstalling SQL Server Such a Pain?

Simple Talk, August 30, 2016
Views: 146 | Hits 7

A developer friend of mine recently, upon the briefest mention of SQL Server, descended unexpectedly into a rant about the pain of getting rid of the blasted thing. I was somewhat taken aback. “Surely...

LLBLGen Pro v5.1 EAP1 released!

Frans Boumas blog, August 30, 2016
Views: 119 | Hits 1

Today we released our first Early Access Program build for LLBLGen Pro v5.1! When we moved to subscriptions (with perpetual licenses) when we released v5.0, the one thing I wanted to get rid of was th...

SQL SERVER Whitepaper Optimizing SQL Server Network Performance

Journey to SQL Authority with Pinal Dave, August 30, 2016
Views: 125 | Hits 4

I have blogged before regarding how to Identify Application vs Network Performance Issues using SQL Server Dynamic Management Views (DMV). You do have some further diagnostics as well as optimizations...

SQL SERVER GetRegKeyAccessMask : Could Not Get Registry Access Mask For Registry Key SQL Server Cluster

Journey to SQL Authority with Pinal Dave, August 29, 2016
Views: 101 | Hits 1

I have been getting many requests from my HIRE-ME page and a few of them are getting change to my blog. This is the outcome of one of my clients who was having a strange issue. They were having 2 node...

How to Get Started with SQL Server 2016? Interview Question of the Week #085

Journey to SQL Authority with Pinal Dave, August 28, 2016
Views: 112 | Hits 2

Interviews are two way streets, sometime interviewer asks questions and sometime candidate asks questions. In a recent interview, I was asked by a candidate "How to Get Started with SQL Server 2016?"...

SQL SERVER How to Fix Error 8134 Divide by Zero Error Encountered

Journey to SQL Authority with Pinal Dave, August 27, 2016
Views: 150 | Hits 3

Here is one of the most popular questions: How to overcome (Error 8134) Divide by Zero Error Encountered in SQL Server?First appeared on SQL SERVER – How to Fix Error 8134 Divide by Zero Error Encount...

Restore or Attach Database Without Log File SQL in Sixty Seconds #082

Journey to SQL Authority with Pinal Dave, August 26, 2016
Views: 194 | Hits 4

One of the most common question I get on blog is - how do I attach database without log file. I have previously blogged about it over here. I request you to read this blog post if you want a solution ...

Predicates With Subqueries

Simple Talk, August 25, 2016
Views: 135 | Hits 8

The ALL, SOME and ANY predicates aren't much used in SQL Server ,but they are there. You can use the Exists() predicate instead but the logic is more contorted and difficult to read at a glance. Set...

SQL Server for Linux

Simple Talk, August 25, 2016
Views: 136 | Hits 5

Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform, it could also provide a useful alternative platform, and a more obvious altern...