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

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

SQL SERVER Generate Different Random Number for Each Group Using RAND() Function

Journey to SQL Authority with Pinal Dave, April 25, 2015
Views: 30 | Hits

You know that RAND() function in SQL Server generates a random float value 0 through 1 (excluding 0 and 1). Let us create the following dataset CREATE TABLE #random(no INT) INSERT INTO #random(no) SEL...

SQL Server Error While Enabling CDC on a Table The specified @server is invalid (valid values are returned by sp_helpserver)

Journey to SQL Authority with Pinal Dave, April 24, 2015
Views: 69 | Hits 1

Every environment is different and it is no doubt some of these environment changes can give you results that are not expected. Recently one of my blog reader followed below blogs: SQL SERVER Introdu...

SQL SERVER Different Methods to Know Parameters of Stored Procedure

Journey to SQL Authority with Pinal Dave, April 24, 2015
Views: 58 | Hits 4

Suppose you have a stored procedure with some input parameters. There are two methods to know the list of parameters defined in a stored procedure. Let us create the following stored procedure CREATE ...

Hey DBA Watch Your Vendors! Hey Vendors Try a Little Harder! Notes from the Field #077

Journey to SQL Authority with Pinal Dave, April 23, 2015
Views: 85 | Hits 3

[Note from Pinal]: This is a 77th episode of Notes from the Fieldseries. Every week, I personally wait for the notes from the fields from Mike because it containslessons of life which directly impacts...

Time Slots - An Essential Extension to Calendar Tables

Simple Talk, April 22, 2015
Views: 54 | Hits 2

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of variou...

Polyglot Persistence Using DDD and Repository Unit of Work

The Code Project Latest Articles, April 22, 2015
Views: 71 | Hits 8

Working with different data stores (SQL, NoSQL ..) in high performance enterprise application using DDD and Repository unit of work pattern...

Installing and Configuring PostgreSQL 9.4 on Linux Mint/Ubuntu

The Code Project Latest Articles, April 22, 2015
Views: 71 | Hits 3

Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the p...

SQL SERVER How to Identify a DB is Using Cross Database Transactions?

Journey to SQL Authority with Pinal Dave, April 22, 2015
Views: 74 | Hits 4

I cannot iterate this often, some of the best learnings always come from times you least expect a question to come from. Recently, when I was at a conference in Delhi, one of the attendees came to me ...

Symmetric Web Server

The Code Project Latest Articles, April 21, 2015
Views: 79 | Hits 5

Lightweight SQL & HTML Web Server Reporting...

SQL SERVER Split Comma Separated List Without Using a Function

Journey to SQL Authority with Pinal Dave, April 21, 2015
Views: 98 | Hits 20

The best way to learn something is to revisit some of the older blogs and then look at finding a more efficient way to work on the same problem. Recently I was looking at the forums to find a question...

SQL SERVER How to View the Dirty Pages In Memory of a Database?

Journey to SQL Authority with Pinal Dave, April 20, 2015
Views: 76 | Hits 2

I always get an opportunity to talk on topics that are basic from time to time. As I was preparing for GIDS 2015 (Great Indian Developer Summit) this year, I was vividly remembering one of the convers...

Interview Question of the Week #016 How to Take Database Offline

Journey to SQL Authority with Pinal Dave, April 19, 2015
Views: 80 | Hits 3

Here is the question, I received in the recent conference where I was presenting on Database Technology. Question: What does it mean by Taking Database Offline and How to do it? Answer: Taking databas...

SQL SERVER Create Login with SID Way to Synchronize Logins on Secondary Server

Journey to SQL Authority with Pinal Dave, April 18, 2015
Views: 126 | Hits 18

How many times you had a problem where you have deployed a high availability solution, but the application is not able to use database and getting login failed for user after failover? Note that this ...

Capture SQL Server queries fired from your Application

The Code Project Latest Articles, April 17, 2015
Views: 153 | Hits 30

This article describes how to create a handy tool to capture the SQL Queries, stored procedures and functions that are fired from your application. This will help developers in diagnosing the code rel...

SQLAuthority News Presenting 3 Technology Session at GIDS 2015

Journey to SQL Authority with Pinal Dave, April 17, 2015
Views: 86 | Hits

Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5years. Just like every year, this year, I will be presenting...

Announcing General Availability of Azure Premium Storage

ScottGus Blog, April 16, 2015
Views: 85 | Hits

Im very excited to announce the general availability release of Azure Premium Storage. It is now available with an enterprise grade SLA and is available for everyone to use. Microsoft Azure now offer...

SQL SERVER Walking the Table Hierarchy in Microsoft SQL Server Database Notes from the Field #076

Journey to SQL Authority with Pinal Dave, April 16, 2015
Views: 105 | Hits 1

[Note from Pinal]: This is a 76th episode of Notes from the Fieldseries.Hierarchy is one of the most important concepts in SQL Server but there are not clear tutorial for it.I have often observed that...

Microsoft To Kill SQL Server 2005 Support in 2016

Microsoft Certified Professional Magazine Online | Todays Top Picks, April 15, 2015
Views: 133 | Hits 10

Organizations running SQL Server 2005 will be cut off when it comes to official support next year, Microsoft announced this week....

SQL SERVER Finding What Policies Are Enabled on Our Databases

Journey to SQL Authority with Pinal Dave, April 15, 2015
Views: 94 | Hits

When I wrote about Policy Management last week (SQL SERVER Introduction to PolicyManagement), lesser did I know I will get queries from blog readers on the basics. As I always said, Policy Management...

SQL SERVER Script Removing Multiple Databases from Log Shipping

Journey to SQL Authority with Pinal Dave, April 14, 2015
Views: 98 | Hits 2

Have you ever come across a situation where you have large number of databases in log shipping and you have to remove all of them? If you use SQL Server Management Studio, it would take a long time be...

SQL SERVER Is XP_CMDSHELL Enabled on the Server?

Journey to SQL Authority with Pinal Dave, April 13, 2015
Views: 104 | Hits

I am not a big fan of using command line utilities in general. But from time to time I do explore and play around with command line tools that make my life easier. Having said that, when working with ...

Interview Question of the Week #015 How to Move TempDB to Different Drive

Journey to SQL Authority with Pinal Dave, April 12, 2015
Views: 116 | Hits 12

Here is one of the most popular questions I often come across- Question – How to move the TempDB to differentdrive when the log files are filled? Answer – In most of the cases which I have observed on...

SQL SERVER CONCAT function and NULL values

Journey to SQL Authority with Pinal Dave, April 11, 2015
Views: 107 | Hits 3

CONCAT is the new T-SQL function introduced in SQL Server 2012. It is used to concatenate the values. It accepts many parameter values seperated by comma. All parameter values are concatenated to a si...

SQL SERVER Login Failed For User Reason Server is in Script Upgrade Mode

Journey to SQL Authority with Pinal Dave, April 10, 2015
Views: 103 | Hits 3

I just cant get enough of the error messages that land into my Inbox almost every single day. I do my due diligence of making a search in my blogs and I try to hang around in the forums from time to t...

SQL SERVER The Basics of the File System Task Part 2 Notes from the Field #075

Journey to SQL Authority with Pinal Dave, April 9, 2015
Views: 96 | Hits 2

[Note from Pinal]: This is a new episode of Notes from the Fieldseries. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story.It is...

SQL SERVER Introduction to Policy Management

Journey to SQL Authority with Pinal Dave, April 8, 2015
Views: 116 | Hits 1

As March comes, most of us are trying to chase our dreams and hope the much awaited yearend review comes good for us. I know many pray and dont realize it is just an assessment of what was done the wh...

Asynchronous SQL Database Wrapper

The Code Project Latest Articles, April 7, 2015
Views: 106 | Hits 6

A simple but powerful class to simplify executing T-SQL commands asynchronously...

SQL SERVER What is Filtered Statistics?

Journey to SQL Authority with Pinal Dave, April 7, 2015
Views: 118 | Hits 36

Continuous learning is the only way to keep myself up-to-date with SQL Server product features. While I was working for a demo to show usage of SQL Server Statistics, I came across feature called Filt...

SQL SERVER Transaction Log Backup Failing After Rebuilding Database Log File

Journey to SQL Authority with Pinal Dave, April 6, 2015
Views: 94 | Hits 1

Speaking at community events get me really energized. It is wonderful to connect with people who build some of the greatest code ever for their respective organizations. Last weekend, I was at a confe...

Interview Question of the Week #014 How to DELETE Duplicate Rows

Journey to SQL Authority with Pinal Dave, April 5, 2015
Views: 109 | Hits 17

Here is another very common question I often received, which candidates face in the interview. Question: How to delete duplicate rows in SQL Server (considering there is an identity column in table)? ...

SQL SERVER An Observation SET vs SELECT in T-SQL

Journey to SQL Authority with Pinal Dave, April 4, 2015
Views: 138 | Hits 17

In SQL Server both SET and SELECT can be used to assign a value to a variable as shown in the following example DECLARE @no INT SET @no=10 SELECT @no AS no GO DECLARE @no INT SELECT @no=10 SELECT @no ...

SQL SERVER Log Shipping Sharing Tab Missing in Folder Properties

Journey to SQL Authority with Pinal Dave, April 3, 2015
Views: 103 | Hits 1

Building a solution for some sort of disaster site is critical for every organization that thinks about business continuity. One of the proven for ages is a solution around Log Shipping. Though one of...

SQL SERVER 3 Common Mistakes of Agile Development Notes from the Field #074

Journey to SQL Authority with Pinal Dave, April 2, 2015
Views: 94 | Hits 3

[Note from Pinal]: This is a 74th episode of Notes from the Fieldseries. Agile is a time boxed, iterative approach to software delivery that builds software incrementally from the start of the project...

Deploying the same database to many different RDBMSs

Simple Talk, April 1, 2015
Views: 93 | Hits 5

With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard tha...

SQL SERVER Quiz on knowing DATEPART and DATENAME Behaviors

Journey to SQL Authority with Pinal Dave, April 1, 2015
Views: 86 | Hits 1

Playing around with date and time datatypes can be loads of fun. I hope you got the pun intended when I say it is fun. Most of the developers working with date and time datatypes feel it is a pain. I ...

SQL Server 2012 Metadata

The Code Project Latest Articles, March 31, 2015
Views: 87 | Hits 3

This tip explains SQL Server metadata information. It will provide internal details of all available SQL Server 2012 Metadata....

SQL SERVER Script to find SQL Startup Account using WMIC

Journey to SQL Authority with Pinal Dave, March 31, 2015
Views: 82 | Hits

Friends are your lifeline that keep your life interesting. I have various friends circles that range from family, acquaintances, work and the most exciting circle is the technical circles. Most of the...

SQL SERVER Using MaxTransferSize parameter with SQL Server Backups

Journey to SQL Authority with Pinal Dave, March 30, 2015
Views: 96 | Hits 2

Off late I have been writing a lot around SQL Server backups and administration topics. I have seen a lot of my readers have been enjoying some of the deep conversations I have with people in the indu...

Create a CRUD web app using JQuery Mobile & WebSQL

The Code Project Latest Articles, March 29, 2015
Views: 141 | Hits 6

Demonstrates how to use SQLite database for mobile development...

Interview Question of the Week #013 Stored Procedure and Its Advantages How to Create Stored Procedure

Journey to SQL Authority with Pinal Dave, March 29, 2015
Views: 144 | Hits 2

There are some questions which are so old that they should not be asked in the interview and gets old. Here is one of the questions I have spotted so many times in the interview that if co-interviewer...

SQL SERVER System procedures to know SQL Server Version

Journey to SQL Authority with Pinal Dave, March 28, 2015
Views: 108 | Hits 2

There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? They are SP_SERVER_INFO and EXEC XP_MSVER EXEC s...

SQL SERVER Find the Growth Size for All files in All Databases

Journey to SQL Authority with Pinal Dave, March 27, 2015
Views: 107 | Hits 3

I am a big time advocate of some common best practices that I see in the industry. These have been ingrained into every session that I do be it SQL Server, MySQL or any other databases. Though I work ...

SQL SERVER Mistake to Avoid: Duplicate and Overlapping Indexes Notes from the Field #073

Journey to SQL Authority with Pinal Dave, March 26, 2015
Views: 112 | Hits 9

[Note from Pinal]:In this episode of the Notes from the Field series database expert KathiKellenbergerexplains about indexes and its impact. We often believe that indexes will improve the performance ...

SQL Server Spatial Indexes

Simple Talk, March 25, 2015
Views: 24 | Hits

Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique cal...

SQL SERVER Knowing Nested Transactions Behavior with SQL Server

Journey to SQL Authority with Pinal Dave, March 25, 2015
Views: 111 | Hits 8

SQL Server is an interesting database system that baffles me every single day that I get to learn something new. This blog has been my way to share these learnings. Every time I write something new, m...

SQL SERVER Where is ERRORLOG? Various Ways to Find its Location

Journey to SQL Authority with Pinal Dave, March 24, 2015
Views: 89 | Hits 4

Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. There have been many occasions where I need to guide them...

Windows 10 SDK preview and dev tools released

Laurent Duveau, March 23, 2015
Views: 88 | Hits 4

We now have the (preview) tools to start developing for the Windows universal app platform!Good news we dont have to wait until BUILD conference!Read the announcement and get the download links here:h...

SQL SERVER Backup and Restore Behavior of ReadOnly Filegroup Databases

Journey to SQL Authority with Pinal Dave, March 23, 2015
Views: 100 | Hits 2

Last week I wrote about SQL SERVER Marking Filegroup as ReadOnly with SQLServer and it got me interested into few key questions. One of the questions someone asked was, how will backups behave? Are t...

Interview Question of the Week #012 Steps to Restore Bak File to Database

Journey to SQL Authority with Pinal Dave, March 22, 2015
Views: 123 | Hits 13

Here is the question, I was asked the other day at the conference. Question: If I have a .bak file and I want to restore it database what are the various steps involved in it. Assume that I do notknow...

SQL SERVER Trivia Days in a Year

Journey to SQL Authority with Pinal Dave, March 21, 2015
Views: 113 | Hits 4

Every time I wrote a blog, I tend to get back to most of them via the search. Most of you ask me questions and I do few simple search back to make sure I am able to address them. Yesterday as I was se...