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

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

SQL SERVER A Practical Use of Backup Encryption

Journey to SQL Authority with Pinal Dave, October 1, 2014
Views: 37 | Hits 3

Backup is extremely important for any DBA. Think of any disaster and backup will come to rescue usersin adverse situation. Similarly, it is very critical that we keep our backup safe as well. If your ...

SQL SERVER A Pratical Use of Backup Encryption

Journey to SQL Authority with Pinal Dave, October 1, 2014
Views: 98 | Hits 2

Backup is extremely important for any DBA. Think of any disaster and backup will come to rescue usersin adverse situation. Similarly, it is very critical that we keep our backup safe as well. If your ...

Microsoft Releases SQL Server 2008 R2 SP3

Microsoft Certified Professional Magazine Online | Todays Top Picks, September 30, 2014
Views: 70 | Hits 3

SQL Server 2008 Release 2 Service Pack 3 has been released by Microsoft....

Windows Form Design at Run Time

The Code Project Latest Articles, September 30, 2014
Views: 86 | Hits 4

Windows Form Design at Run Time.Panel has been used as a Form where user can Add ,Move controls.user can Add,text,items,colors and etc using Property Window.Bind Data to DatagridView,ListView,ComboBox...

SQL SERVER UPDATE From SELECT Statement with Condition

Journey to SQL Authority with Pinal Dave, September 30, 2014
Views: 93 | Hits 3

An email from an old college friendlanded my mailbox: “Hey Pinal,” I have two tables. I want to conditionally update data in one table based on another table. How can I do that. I have included sample...

SQL SERVER How to Check Snapshot Isolation State of Database

Journey to SQL Authority with Pinal Dave, September 29, 2014
Views: 110 | Hits 2

It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same. SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed...

SQL SERVER SQL Server 2008 R2 Service Pack 3 Download

Journey to SQL Authority with Pinal Dave, September 28, 2014
Views: 193 | Hits 1

It has been a long time since SQL Server 2008 R2 got Service Pack Update. Microsoft has finally released SQL Server 2008 R2 service pack 3and its feature pack.SQL Server 2008 R2 SP3 contains fixes to ...

SQL SERVER Extension of the SQL Server Natively Compiled Stored Procedures

Journey to SQL Authority with Pinal Dave, September 27, 2014
Views: 272 | Hits 4

Earlier I wrote a blog post aboutthe Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures. In the blog...

A better way to play with HQL in Orchard

More Whidbey stuff, September 26, 2014
Views: 276 | Hits 3

In previous posts, Ive shown how to query Orchard with straight HQL. However, I havent provided a good environment to run and debug these queries so far, because I didnt have one. As a matter of facts...

SQL SERVER Performance Dashboard: Historic Information

Journey to SQL Authority with Pinal Dave, September 26, 2014
Views: 289 | Hits 8

There are a lot of games that I play with my daughter in spare time. Some of them are for just for fun and a lot of them are fun filled with some learning. As she started to grow up, it was important ...

SQL SERVER Database Taking Long Time to Create Notes from the Field #047

Journey to SQL Authority with Pinal Dave, September 25, 2014
Views: 219 | Hits 1

[Notes from Pinal]: There are few things which confuse us when we encounter first time, however, there are few concepts which confuses us even though we face them multiple times. One of the such subje...

Querying Orchard fields with HQL

More Whidbey stuff, September 24, 2014
Views: 222 | Hits 4

Before projections, the official word on fields was that they werent for querying (they are stored in an XML blob on the content item record). Projections enabled field querying for the first time, th...

SQL SERVER Performance Dashboard: Current Activity Section Reports

Journey to SQL Authority with Pinal Dave, September 24, 2014
Views: 213 | Hits 3

You are driving on the highway and you want to know your speed because there are cops generally in that areas you watch the dashboard. Your kid seems to be fiddling with your cell phone you want to ...

FreedReadR: RSS Reader Created With AngularJS (part 2 of 2)

The Code Project Latest Articles, September 23, 2014
Views: 196 | Hits 8

Learn Angular and Firebase API (AngularFire) for live storage of data via Internet using nosql db....

SQL SERVER SSMS: Performance Dashboard Reports Home Page details

Journey to SQL Authority with Pinal Dave, September 23, 2014
Views: 198 | Hits 4

Earlier we discussed in detail what the SSMS: Server Dashboard Report looks like when working with SQL Server Management Studio standard reports. These dashboard reports are an arsenal of amazing weal...

New D-Series of Azure VMs with 60% Faster CPUs, More Memory and Local SSD Disks

ScottGus Blog, September 22, 2014
Views: 200 | Hits 2

Today I’m excited to announce that we just released a new set of VM sizes for Microsoft Azure. These VM sizes are now available to be used immediately by every Azure customer. The new D-Series o...

Improving the Quality of SQL Server Database Connections in the Cloud

Simple Talk, September 22, 2014
Views: 202 | Hits 2

To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile, TDS is still used to conne...

SQL SERVER SSMS: Performance Dashboard Installation and Configuration

Journey to SQL Authority with Pinal Dave, September 22, 2014
Views: 192 | Hits 7

If the standard set of reports were not enough, in this blog, let me introduce an interesting addition to the reports. This is called as Performance Dashboard reports. There are a set of predefined ad...

SQL SERVER A Question on SSMS Prompt about Connect to Server

Journey to SQL Authority with Pinal Dave, September 21, 2014
Views: 214 | Hits 1

Today is Sunday, so letting us have some fun thing to discuss and think about. If you have not read my earlier blog postSQL SERVER Connecting to Azure Storage with SSMS. I have discussed about how to...

SQL SERVER Connecting to Azure Storage with SSMS

Journey to SQL Authority with Pinal Dave, September 20, 2014
Views: 291 | Hits 7

SQL Server Management Studio can now connect to Azure Storage. It is very simple to connect to Azure Storage. First open the Object Explorer in SQL Server Management Studio (SSMS).Now click on Connect...

SQL SERVER SSMS: Index Usage Statistics, Physical Statistics & User Statistics

Journey to SQL Authority with Pinal Dave, September 19, 2014
Views: 265 | Hits 4

When I used to be in the consulting business, the most request session or topics always revolved around Performance Tuning. And whenever I talk to folks around what they want to get covered, they ofte...

Filling In Missing Values Using the T-SQL Window Frame

Simple Talk, September 18, 2014
Views: 110 | Hits 3

Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of r...

Querying Orchard in HQL

More Whidbey stuff, September 18, 2014
Views: 203 | Hits 4

Orchard has two APIs on IContentManager to query content items: Query, and HqlQuery. Query is the older API, but its also the simplest. Its great when you want to perform a simple query such as get al...

A Very Simple Example of HTML 5 OFFLINE Database (indexedDB and WebSql)

The Code Project Latest Articles, September 18, 2014
Views: 226 | Hits 11

This article explains the basic knowledge about the browser databases that comes in handy when working with the HTML 5 Offline application to create, edit, modify or delete the data of a table in data...

SQL SERVER Using the SSIS Term Extraction for Data Exploration Notes from the Field #046

Journey to SQL Authority with Pinal Dave, September 18, 2014
Views: 247 | Hits 1

[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 Using the SSIS Term Extraction ...

SQL SERVER SSMS: Resource Locking and Object Execution Statistics Report

Journey to SQL Authority with Pinal Dave, September 17, 2014
Views: 265 | Hits 2

As a DBA or SQL Developer, the amount of time we work with SQL Server Management can never be measured. As a database person, these hidden gems of SQL Server can never be underestimated. With each rel...

SQL SERVER Location of Natively Compiled Stored Procedure and Naming Convention

Journey to SQL Authority with Pinal Dave, September 16, 2014
Views: 238 | Hits 1

Yesterday I wrote aboutSQL SERVER Beginning In-Memory OLTP with Sample Example. One of the questions I received right after I published a blog post was why do I call stored procedurenatively coded st...

119 SQL Code Smells

Simple Talk, September 15, 2014
Views: 232 | Hits 27

Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest des...

SQL SERVER Beginning In-Memory OLTP with Sample Example

Journey to SQL Authority with Pinal Dave, September 15, 2014
Views: 237 | Hits 6

In-Memory OLTP is a wonderful new feature introduced in SQL Server 2014. My friend Balmukund Lakhani has written amazing series on A-Z of In-Memory on his blog. All serious learner should study it for...

Article 8:Handling Input And Storage In Android with A Real Time Online Opinion Polarity Mining App

The Code Project Latest Articles, September 14, 2014
Views: 200 | Hits 5

Learn easy data management, SqlLite database, XML Web services, File Database in Android with a Real time App...

Google Drive Trick Google Spreadsheet Formatting Dates to String

Journey to SQL Authority with Pinal Dave, September 14, 2014
Views: 157 | Hits 1

I have been using google drive and google spreadsheet for a while. I work with experts around the world and we all use different date format. The biggest confusion which often happens when we are shar...

SQL SERVER Flushing Transaction Log to Disk for Current Database

Journey to SQL Authority with Pinal Dave, September 13, 2014
Views: 154 | Hits 2

I have written quite a while on Delayed Durability and every blog post when I think it will be the last post on this subject, I always get some question in an email and I end up writing a new blog pos...

Azure: SQL Databases, API Management, Media Services, Websites, Role Based Access Control and More

ScottGus Blog, September 12, 2014
Views: 191 | Hits 6

This week we released a major set of updates to Microsoft Azure. This weeks updates include: SQL Databases: General Availability of Azure SQL Database Service Tiers API Management: General Availabil...

SQL Authority News Discount Code for for SQL Live! 360 in November

Journey to SQL Authority with Pinal Dave, September 12, 2014
Views: 120 | Hits

I thought you might be interested to know that Ill be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to expl...

Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask

Simple Talk, September 11, 2014
Views: 119 | Hits 6

The job of retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as, for example, performing heroics with ill-performing queries. This could be why one hesitat...

Hey DBA Go Make a Proactive Investment Today! Notes from the Field #045

Journey to SQL Authority with Pinal Dave, September 11, 2014
Views: 97 | Hits 2

[Note from Pinal]: This is a 45th episode of Notes from the Fieldseries. If you know Mike Walsh, he is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him...

Tackling database drift with SQL Lighthouse

Simple Talk, September 10, 2014
Views: 83 | Hits 4

Red Gates upcoming product – SQL Lighthouse – gives you the What, the Who, the When and the How of database drift so you can make things right. A few months ago I wrote a post about a new product we a...

Article 8 - Handling Input and Storage on Android

The Code Project Latest Articles, September 10, 2014
Views: 83 | Hits 3

This articles provides a brief description of different methods that Android platform can provide for a developer to save different data types with different storage methods like Shared Preferences, I...

SQL SERVER Video Introduction to Delayed Durability SQL in Sixty Seconds #074

Journey to SQL Authority with Pinal Dave, September 10, 2014
Views: 80 | Hits 1

EarlierI wrote blog post based on my latest Pluralsight course on learning SQL Server 2014.SQL Server 2014 has introduced many new features and one of performance is Delayed Transaction Durability. Th...

SQL SERVER Delayed Durability Database Level and Transaction Level

Journey to SQL Authority with Pinal Dave, September 9, 2014
Views: 73 | Hits 1

Earlier I have written three articles on the concept of Delayed Durability. You can read them over here. SQL SERVER Basics of Delayed Durability in SQL Server2014 SQL SERVER How to Setup Delayed Dur...

SQL SERVER Simple Example of Delayed Durability

Journey to SQL Authority with Pinal Dave, September 8, 2014
Views: 95 | Hits 5

Earlier I wrote two blog posts on Delayed Durability. Please read them before continuing this example, as they will give you good information about this concept before we start. SQL SERVER Basics of ...

SQL SERVER How to Setup Delayed Durability for SQL Server 2014?

Journey to SQL Authority with Pinal Dave, September 7, 2014
Views: 81 | Hits 2

Yesterday we discussed aboutthe Basics of Delayed Durability in SQL Server 2014. Today we will learn one more topic about this subject –How to Setup Delayed Durability for SQL Server 2014? There are t...

SQL SERVER Basics of Delayed Durability in SQL Server 2014

Journey to SQL Authority with Pinal Dave, September 6, 2014
Views: 96 | Hits 3

SQL Server 2014 has introduced many new features and one of performance is Delayed Transaction Durability. This concept is indeed very interesting. To explain this feature in detail, we will require t...

Are you bad enough to join The DBA Team?

Simple Talk, September 5, 2014
Views: 66 | Hits 3

Steve Jones and Grant Fritchey have emerged from their hide-out in the Cheyenne Mountains to hunt for their next DBA Team adventure. Theres one difference this time: for their special Christmas episod...

SQL Authority News FalafelCON 2014: 2 days with the Best Developers in the World

Journey to SQL Authority with Pinal Dave, September 5, 2014
Views: 85 | Hits 1

It is only two weeks away. On September 20-21, 2014 I will be in San Francisco presenting at an amazing conference of Falafel Conference 2014. I love presenting at various forums on various technologi...

SQL SERVER The Basics of the SSIS Execute SQL Task Notes from the Field #044

Journey to SQL Authority with Pinal Dave, September 4, 2014
Views: 74 | Hits 1

[Note from Pinal]: This is a new episode of Notes from the Fieldseries. SSIS is an interesting concept. There are more hidden features with SSIS than any other product. Additionally, there are many vi...

How to setup database versioning tool RoundhousE

The Code Project Latest Articles, September 3, 2014
Views: 65 | Hits 7

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another....

SQL SERVER Live Plan for Executing Query SQL in Sixty Seconds #073

Journey to SQL Authority with Pinal Dave, September 3, 2014
Views: 75 | Hits 4

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introducedlive plans.For query before you execute it, you can see the estimated executi...

SQL SERVER Live Plans for Long Running Queries

Journey to SQL Authority with Pinal Dave, September 2, 2014
Views: 79 | Hits 8

If you are a SQL Server DBA or developer who is majorly dealing with queries which are running for a long time, you may have one request every time you see a long running query. The request is how to ...

Preventing SQL Injection Attack ASP.NET - Part I

The Code Project Latest Articles, September 1, 2014
Views: 86 | Hits 15

SQL Injection is a very common attack in web applications. This article explains how SQL Injection occurs and how to prevent it....