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

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

SQL Server Auditing and Recovery With ApexSQL Log 2016

Journey to SQL Authority with Pinal Dave, February 9, 2016
Views: 13 | Hits 1

ApexSQL Log is a powerful SQL Server transaction reader for forensic auditing and rollback of malicious and/or unintended changes for Microsoft SQL Server. It is an ideal cost solution for recovery, r...

SQL SERVER How to Connect Using NT AUTHORITY\SYSTEM Account?

Journey to SQL Authority with Pinal Dave, February 8, 2016
Views: 46 | Hits 1

Sometimes it is needed to connect to SQL Server using System account. Dont literally ask me if this is a valid scenario in first place. Someone just pinged to say they want to do it. I was personally...

Interview Question of the Week #057 What is GO in SQL SERVER?

Journey to SQL Authority with Pinal Dave, February 7, 2016
Views: 79 | Hits 5

GO is not a Transact-SQL statement; it is often used in T-SQL code. Go causes all statements from the beginning of the script or the last GO statement (whichever is closer) to be compiled into one exe...

MySQL How to Generate Random Number

Journey to SQL Authority with Pinal Dave, February 6, 2016
Views: 74 | Hits 1

In MySQL, UUID() function returns Universal Unique Identifier that generates 36 characters long value which is 5 part hexadecimal numbers. If you want to create random password, you can make use of th...

SQL SERVER Install Error The /UIMode setting cannot be used in conjunction with /Q or /QS

Journey to SQL Authority with Pinal Dave, February 5, 2016
Views: 86 | Hits

Doing repetitive tasks is something everyone hates. I am sure many of us have resorted to ingenious techniques to figure out doing the task efficiently. There is no standard tool or technique that eve...

SQL SERVER SSIS Get Started with the For Loop Container Notes from the Field #113

Journey to SQL Authority with Pinal Dave, February 4, 2016
Views: 74 | Hits 2

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Get Started with the For Loop C...

SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts

Journey to SQL Authority with Pinal Dave, February 3, 2016
Views: 97 | Hits 6

InMemory is an awesome concept and I have been fortunate to learn about the same from my friends in the industry over blogs. It holds deep concepts and is sometimes tough to understand how the buildin...

SQL SERVER dbForge Object Search for SQL Server

Journey to SQL Authority with Pinal Dave, February 2, 2016
Views: 94 | Hits 3

SSMS is a nice tool for database developers. However, it is far from being ideal, and this is because some routine operations in SSMS are extremely inconvenient to perform. Very often, developers face...

LLBLGen Pro v5.0 Beta has been released!

Frans Boumas blog, February 1, 2016
Views: 75 | Hits 5

Since the first commit into the v5.0 fork back in the Fall 2014, weve been hard at work to make LLBLGen Pro v5.0 a worthy successor of the highly successful v4.x version. Today, weve released our hard...

SQL SERVER 2016 IF EXISTS Functions on SQL Azure Databases and More

Journey to SQL Authority with Pinal Dave, February 1, 2016
Views: 79 | Hits 2

The experimentations of working with the next release of SQL Server is always fun and when I wrote the blog SQL Server 2016 T-SQL Enhancement Drop if Exists clause, lesser did I know such capabiliti...

Interview Question of the Week #056 How to fix Installation Failure Rule Setup account privileges Failed in SQL Server

Journey to SQL Authority with Pinal Dave, January 31, 2016
Views: 73 | Hits

Sometimes in the interviews I observe that users are able to answer all the theoretical questions correct but when it is about doing practical they fail. A while ago, when I was helping a large organi...

SQL SERVER Script level upgrade for database master failed because upgrade step sqlagent100_msdb_upgrade.sql

Journey to SQL Authority with Pinal Dave, January 30, 2016
Views: 105 | Hits

I do apply patches to my SQL instances as and when they are released by Microsoft. This is important because I always feel keeping the bits uptodate is essential because I dont want to get infected as...

SQL SERVER 2016 Error Reasons: Msg 10778, Level 16 Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported

Journey to SQL Authority with Pinal Dave, January 29, 2016
Views: 81 | Hits

When I was writing the blog SQL SERVER 2016 InMemory OLTP support for Foreign Key, it felt like a great addition to SQL Server. I felt there must be something that I might be missing as the obvious. ...

A Database to Diagram for

Simple Talk, January 28, 2016
Views: 76 | Hits 12

I’m no database designer but I do occasionally need to build a very simple database model, no more than a small handful of tables, to test out some code for an article or presentation. The other day, ...

SQL SERVER Fixing Annoying Network Binding Order Error Notes from the Field #112

Journey to SQL Authority with Pinal Dave, January 28, 2016
Views: 85 | Hits 2

[Note from Pinal]:In this episode of the Notes from the Field series database expert Ryan Adamsexplains a very critical error user receive when binding network error. Ryan is one guy whospends more ti...

SQL SERVER Add failover cluster node fails with number of cluster nodes supported for edition

Journey to SQL Authority with Pinal Dave, January 27, 2016
Views: 84 | Hits 1

A lot of my blog readers contact me via comments and I try my best to reply to all of them. Sometimes issue is so interesting that I ask them to contact via email. This blog is result of such an inter...

Maintaining T-SQL Code Quality Using SQL Code Guard

Simple Talk, January 26, 2016
Views: 2 | Hits

Sometimes you need some functionality in your database build process that isn't quite available. Visual Studio Database projects don't have great ways of reviewing SQL code for potential errors, but i...

Monitoring In-Memory OLTP: What's Important?

Simple Talk, January 26, 2016
Views: 2 | Hits

In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Ser...

SQL SERVER Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Journey to SQL Authority with Pinal Dave, January 26, 2016
Views: 86 | Hits 2

Some errors when encountered take most of us for a spin. In this category the error related to Timeout surely falls. If you are a web developer and receive the same there are a hundred combinations wh...

SQL SERVER Why is My Query Switching to Row Processing and Not Doing Batch Processing?

Journey to SQL Authority with Pinal Dave, January 25, 2016
Views: 82 | Hits

Some of the learnings can lead to another exploration when someone does stump you with something you didnt know. To understand the basics of batch mode and row mode, read the blog SQL SERVER ColumnSt...

Interview Question of the Week #055 How to Convert ASCII to DECIMAL or DECIMAL to ASCII?

Journey to SQL Authority with Pinal Dave, January 24, 2016
Views: 81 | Hits 4

Question: How do you convert ASCII to DECIMAL or DECIMAL to ASCII? Answer: ASCII Returns the ASCII code value of the leftmost character of a character expression. CHAR Fixed-length non-Unicode chara...

SQL SERVER Script: Change Service Account Using WMI / SMO

Journey to SQL Authority with Pinal Dave, January 23, 2016
Views: 75 | Hits 1

Last week I wrote a post where my friend faced problem because he changed the service account of SQL Server from services. mass rather than SQL Server Configuration Manager. SQL SERVER Performance co...

SQL SERVER 2016 Creating Additional Indexes with Clustered ColumnStore Indexes

Journey to SQL Authority with Pinal Dave, January 22, 2016
Views: 89 | Hits 2

Every version of SQL Server brings new capabilities that enhance the features that were introduced in the previous versions. I am sure the team is working based on the feedbacks given by customers as ...

SQL SERVER FIX: Msg 4335, Level 16, State 1 The specified STOPAT time is too early

Journey to SQL Authority with Pinal Dave, January 21, 2016
Views: 80 | Hits 1

While trying to prepare for a demo, I ran into some interesting error. When I searched for error on the internet, there were not many clear answers so I thought of sharing on my blog. Actually, my dem...

SQL Database Simulator in the Browser

The Code Project Latest Articles, January 20, 2016
Views: 121 | Hits 7

This article presents a client-side, javascript Relational Database Simulator in the browser, using SQL commands to Create, Read, Insert, Update and Delete in-browser table data, as well as formatting...

Hyper V: Error and Fix Fix Boot failure. Reboot and Select proper Boot device

Journey to SQL Authority with Pinal Dave, January 20, 2016
Views: 101 | Hits 1

While trying to deploy new machines on my Hyper-V, I faced an error. Boot failure. Reboot and Select proper Boot device or Insert Boot Media in selected Boot device It was a VHD file which I downloade...

De-duplicating Delimited Lists in SQL Server

Simple Talk, January 19, 2016
Views: 6 | Hits

/* In a recent article 'Removing Duplicates from Strings in SQL Server', Aaron Bertrand comes up with the interesting problem of removing duplicates from lists of strings. The example he gives is 'Br...

SQL SERVER 2016 InMemory OLTP support for Foreign Key

Journey to SQL Authority with Pinal Dave, January 19, 2016
Views: 101 | Hits 2

When InMemory OLTP was introduced in SQL Server 2014, there were a number of limitations that restricted customers to effectively use the capability. One of the most commonly asked capability was arou...

SQL SERVER Dedicated Database Development with SQL Source Control

Journey to SQL Authority with Pinal Dave, January 18, 2016
Views: 86 | Hits 6

We all make mistake and we all wish that we have not made those mistakes. In the field of the development, there are proper solutions, but in the world of SQL, there are not many solutions. I recently...

Interview Question of the Week #054 Retrieve User Defined Object Details from sys.objects

Journey to SQL Authority with Pinal Dave, January 17, 2016
Views: 102 | Hits 4

Sometimes questions in the interview are extremely open ended and such questions can be very useful for candidate to play around with. For example, in one of the recent interview one of the interviewe...

SQL SERVER Performance counter missing! DMV sys.dm_os_performance_counters is Empty

Journey to SQL Authority with Pinal Dave, January 16, 2016
Views: 101 | Hits

The topic around performance tuning is the most sought out search on this blog. Almost every single day the top search that lands here are around performance or around some random errors one might rec...

SQL SERVER Starting / Stopping SQL Server Agent Services using PowerShell

Journey to SQL Authority with Pinal Dave, January 15, 2016
Views: 108 | Hits 1

Writing utility scripts are one way to become smarter when working with computers. From time to time I get asked about some tasks folks use repetitively and are being counterproductive. On this note, ...

SQL SERVER Live Query Statistics in 2016 and More! Notes from the Field #111

Journey to SQL Authority with Pinal Dave, January 14, 2016
Views: 89 | Hits 1

[Note from Pinal]:In this episode of the Notes from the Field series database expert Mike Lawell explains about Live Query Statistics in SQL Server 2016. Statistics are heart of SQL Server. They play ...

Data Manipulation in R: Beyond SQL

Simple Talk, January 13, 2016
Views: 6 | Hits

Although SQL is an obvious choice for retrieving the data for analysis, it strays outside it's comfort zone when dealing with pivots and matrix manipulations. R includes a number of packages that can...

Declarative SQL: Using CHECK() & DEFAULT

Simple Talk, January 13, 2016
Views: 70 | Hits 1

SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that underlie the data and its integrity. When used properly, constraints can avoid having to ...

SQL SERVER System.IO.FileNotFoundException: Could not load file or assembly

Journey to SQL Authority with Pinal Dave, January 13, 2016
Views: 103 | Hits 3

In a recent R&D operation, I was trying to use some SQLCLR assembly as part of the installation process. It was not easy but it got me into a mess that I thought was worth debugging. One of the intere...

SQL SERVER FIX: Msg 7395, Level 16, State 2 Unable to start a nested transaction for OLE DB provider

Journey to SQL Authority with Pinal Dave, January 12, 2016
Views: 106 | Hits 1

While playing with linked server from SQL Server to SQL Server, I faced few errors and fixed them as well. It has become a custom to get errors working with Linked Servers almost every time. I persona...

SQL SERVER Working with Event Viewer and PowerShell

Journey to SQL Authority with Pinal Dave, January 11, 2016
Views: 94 | Hits 3

Sometimes I go into these simple explorations that make me learn something new that gets me off the routine. SQL Server is always on the agenda and that passion will never die. This exploration was ba...

Interview Question of the Week #053 What is the Difference Between Deterministic Functions and Nondeterministic Functions?

Journey to SQL Authority with Pinal Dave, January 10, 2016
Views: 111 | Hits 16

Some questions are so theoretical that I believe they really do not add too much value if users know that question or not. Here is one such question I am very confident that you agree with my point of...

SQL SERVER FIX: Msg 3169, Level 16, State 1 The database was backed up on a server running version. That version is incompatible with this server.

Journey to SQL Authority with Pinal Dave, January 9, 2016
Views: 107 | Hits 1

At this rate, I think I am going to exhaust the whole error set available inside SQL Server. I am glad that I am able to get into unique situations and then resolve them too. And this is more of a dia...

SQL SERVER SSMA Error: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

Journey to SQL Authority with Pinal Dave, January 8, 2016
Views: 98 | Hits 1

I work majorly on SQL Server but rarely do I get a chance to work on Oracle in general. When some of the error messages reach my inbox, I get intrigued to why some occur. This error message was an out...

Its a New Year, Take Advantage of It Notes from the Field #110

Journey to SQL Authority with Pinal Dave, January 7, 2016
Views: 109 | Hits 1

[Note from Pinal]: This is the first episode of Notes from the Fieldseries in the year 2016 and 110th overall. There is one place where I see the maximum crowd in the new year –fitness center (gym). I...

The SQL Server 2016 Query Store: Built-in Reporting

Simple Talk, January 6, 2016
Views: 15 | Hits

One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is perfo...

SQL SERVER Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool

Journey to SQL Authority with Pinal Dave, January 6, 2016
Views: 104 | Hits 4

Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. Over these years, there is on...

SQL SERVER FIX: sp_rename error Msg 15225 No item by the name of %s could be found in the current database

Journey to SQL Authority with Pinal Dave, January 5, 2016
Views: 113 | Hits 1

Few days back I have written blog containing script for removing space in column name using sp_rename. In case you missed, I am listing them below for quick reference. SQL SERVER Script: Remove Space...

SQL SERVER Someone was trying to hack my SQL Server Logins in Azure!

Journey to SQL Authority with Pinal Dave, January 4, 2016
Views: 123 | Hits 7

When I started to work with SQL Server on Azure VMs, I was completely excited because now the need to build local VMs has become super easy. If I need something for testing, then I know I can get a SQ...

Interview Question of the Week #052 Print String in Reverse Order Without Using Reverse Function

Journey to SQL Authority with Pinal Dave, January 3, 2016
Views: 104 | Hits 8

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with ...

SQL SERVER Script: Finding Cumulative IO Per Database File

Journey to SQL Authority with Pinal Dave, January 2, 2016
Views: 94 | Hits

Sharing SQL Server related scripts is something I tend to do from time to time. At the SQLPass one of the attendees for my session around 42 tips asked, if I have any script that is handy to find the ...

SQL SERVER FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)

Journey to SQL Authority with Pinal Dave, January 1, 2016
Views: 131 | Hits

Getting error and finding the cause is something which I like. And off late over the blogs I have shared a number of such incidents that have helped me figure out stuffs all by myself. Of course, I do...

SQL SERVER Are You Suffering from Unknown SSAS Performance Challenges? Notes from the Field #109

Journey to SQL Authority with Pinal Dave, December 31, 2015
Views: 141 | Hits 4

[Note from Pinal]: This is a new episode of Notes from the Fieldseries. We build our business application with zeal and enthusiasm. We believe it will do well for many years but it is not the case alw...