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

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

Developers Life Disaster Lessons Notes from the Field #039

Journey to SQL Authority with Pinal Dave, July 31, 2014
Views: 6 | Hits

[Note from Pinal]: This is a 39th episode of Notes from the Fieldseries.What is the best solution do you have when you encounter a disaster in your organization. Now many of you would answer that in t...

SQL Authority News Play by Play with Pinal Dave A Birthday Gift

Journey to SQL Authority with Pinal Dave, July 30, 2014
Views: 23 | Hits

Today is my birthday. Personal Note When I was young, I was always looking forward to my birthday as on this day, I used to get gifts from everybody. Now when I am getting old on each of my birthday, ...

SQL SERVER SSMS: Top Object and Batch Execution Statistics Reports

Journey to SQL Authority with Pinal Dave, July 30, 2014
Views: 71 | Hits 6

The month of June till mid of July has been the fever of sports. First, it was Wimbledon Tennis and then the Soccer fever was all over. There is a huge number of fan followers and it is great to see t...

SQL SERVER SSMS: Top Queries by CPU and IO

Journey to SQL Authority with Pinal Dave, July 29, 2014
Views: 66 | Hits 8

Let me start this blog post with a personal story. Personal Story – Dad and I My fascination for computers started way back when I was about to get into highschool. My father once took me to his offic...

Developer Cross-Platform: Fact or Fiction?

Journey to SQL Authority with Pinal Dave, July 29, 2014
Views: 55 | Hits 7

This is a guest blog post by JeffMcVeigh.Jeff McVeigh is the general manager of Performance Client and Visual Computing within Intels Developer Products Division. His team is responsible for the devel...

The SQL of Membership: Equivalence Classes & Cliques

Simple Talk, July 28, 2014
Views: 33 | Hits 1

It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. Howeve...

Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups

Simple Talk, July 28, 2014
Views: 32 | Hits

In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of stor...

SQL SERVER SSMS: Top Transaction Reports

Journey to SQL Authority with Pinal Dave, July 28, 2014
Views: 54 | Hits 5

Let us start with a personal story. Personal Story – My Daughter and I My day has its own part of long meetings and my daughter tries to pull a string here and there to get my attention almost every o...

Developers Life Every Developer is the Incredible Hulk

Journey to SQL Authority with Pinal Dave, July 27, 2014
Views: 95 | Hits 14

The Incredible Hulk is possibly one of the scariest superheroes out there. All superheroes are meant to be out of this world and awe-inspiring, but I think most people will agree with I say The Hulk t...

MySQL UDF Validate Integer Function

Journey to SQL Authority with Pinal Dave, July 26, 2014
Views: 39 | Hits 1

There is a default function in SQL Server called ISNUMERIC to determine if the string is numeric. In SQL Server ISNUMERIC returns 1 for non numerials also. Ex ISNUMERIC (‘,’) returns 1. To avoid this ...

SQL SERVER SSMS: Transaction Log Shipping Status Report

Journey to SQL Authority with Pinal Dave, July 25, 2014
Views: 49 | Hits 4

History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. Most of the cities like Seattle and ma...

SQL SERVER How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio

Journey to SQL Authority with Pinal Dave, July 24, 2014
Views: 77 | Hits 7

This article shows how to use ApexSQL Refactor,a free SQL code formatting and refactoring tool. You can download ApexSQL Refactor, and explore it through the article. ApexSQL Refactor is a free tool, ...

SQL SERVER Andy Defines Basic RDBMS: Isolation in Processes Notes from the Field #038

Journey to SQL Authority with Pinal Dave, July 24, 2014
Views: 59 | Hits 2

[Note from Pinal]: This is a new episode of Notes from the Fieldseries.Every time I give an introductory note, however, this time there is no need of intronote. This note is from Andy and as we all kn...

SQL Authority News Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching

Journey to SQL Authority with Pinal Dave, July 23, 2014
Views: 39 | Hits 2

In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEXs for BI ...

Northwind Database with NoSQL DBreeze

The Code Project Latest Articles, July 23, 2014
Views: 84 | Hits 9

Using NoSQL DBreeze database with ASP.NET on SQL Northwind Database....

SQL SERVER Finding Object Dependencies in SSMS SQL in Sixty Seconds #071

Journey to SQL Authority with Pinal Dave, July 23, 2014
Views: 50 | Hits 6

While we are doing development, we create and drop objects. We build new things and we need to understand the relationships between database objects when we are doing various activities in SQL Server....

SQL SERVER Free Entry to SQLPASS 2014 is Possible

Journey to SQL Authority with Pinal Dave, July 22, 2014
Views: 88 | Hits 5

The other day, I received an email from Dell and I was extremely delighted to read it. It contained details how one can go for FREE to SQLPASS. What is SQLPASS? The three-day event will be marked by a...

SQL SERVER SSMS: Activity All Blocking Transactions

Journey to SQL Authority with Pinal Dave, July 22, 2014
Views: 57 | Hits 6

Working out of India has its own challenges and I enjoy here despite these challenges thrown at me. One of the biggest advantage I have working with Pluralsight is, I can still get my job done by work...

Flawed SQL Server 2012 SP2 ISOs Fixed

Microsoft Certified Professional Magazine Online | Todays Top Picks, July 21, 2014
Views: 161 | Hits 4

Microsoft has corrected an issue with the TechNet and MSDN subscribers' download of SQL Server 2012 Service Pack 2....

Web-based real-time SQL Server Performance Dashboard

The Code Project Latest Articles, July 21, 2014
Views: 118 | Hits 26

SQL Server Performance Dashboard (SSPD) is a small website that shows you performance & problems of one or more SQL Server instances and their databases in near real time....

SQL SERVER Activity Reports Dormant Sessions

Journey to SQL Authority with Pinal Dave, July 21, 2014
Views: 73 | Hits 4

With schools starting for my daughter, I rarely get involved in her daily routine activity. But there is one thing that I dont try to miss the parents-teachers meet. Sometimes it is not about the rep...

Developers Life Every Developer is a Wonder Woman

Journey to SQL Authority with Pinal Dave, July 20, 2014
Views: 57 | Hits 3

We have focused a lot lately on this superhero series. I love fantasy books and movies, and I feel like there is a lot to be learned from them. As I am writing this series, though, I have noticed that...

MySQL How to Format Date in MySQL with DATE_FORMAT()

Journey to SQL Authority with Pinal Dave, July 19, 2014
Views: 80 | Hits 8

MySQL supports formatting the datetime values into a different formats using DATE_FORMAT() function. This function accepts date/datetime values as a first parameter and returns into a specific format ...

SQL SERVER Free intellisense add-in for SSMS

Journey to SQL Authority with Pinal Dave, July 18, 2014
Views: 123 | Hits 27

This article shows how to use ApexSQL Complete, a free SQL Server intellisense add-in. You can download ApexSQL Complete, and play along through the article. ApexSQL Complete is a free SQL Server Mana...

SQL SERVER Beginning Contained Databases Notes from the Field #037

Journey to SQL Authority with Pinal Dave, July 17, 2014
Views: 98 | Hits 7

[Note from Pinal]: This is a newepisode of Notes from the Fields series. Login and Users are very confused concept. Just yesterday I wrote about a difference between Login and User. In Latest version ...

SQL SERVER Difference Between Login and User SQL in Sixty Seconds #070

Journey to SQL Authority with Pinal Dave, July 16, 2014
Views: 95 | Hits 21

“What is the difference between Login and User in SQL Server?” This is a very common question I often receive. Yesterday when I was browsingFacebook, I once again noticed this question once again aske...

West Wind WebSurge - an easy way to Load Test Web Applications

Rick Strahls WebLog, July 15, 2014
Views: 58 | Hits 5

A few months ago on a project the subject of load testing came up. We were having some serious issues with a Web application that would start spewing SQL lock errors under somewhat heavy load. These s...

SQL SERVER SSMS: Memory Consumption Report

Journey to SQL Authority with Pinal Dave, July 15, 2014
Views: 21 | Hits 2

The next in line in this series of reports is the Memory Consumption Report from SQL Server Management Studio. This is a goldmine of a report in my humble opinion and lesser respected. When I used to ...

Questions about SQL Server Data Types You were Too Shy to Ask

Simple Talk, July 14, 2014
Views: 67 | Hits 13

Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions ...

SQL SERVER SSMS: Scheduler Health Report

Journey to SQL Authority with Pinal Dave, July 14, 2014
Views: 25 | Hits 2

Have you ever been to a music concert? It is the most humbling experience one can get as a music lover. The live music with hundreds of musicians in one stage brings goosebumps with the very thought. ...

Developers Life Every Developer is a Harry Potter

Journey to SQL Authority with Pinal Dave, July 13, 2014
Views: 26 | Hits

Harry Potter might not be a superhero in the traditional sense, but I believe he still has a lot to teach us and show us about life as a developer. If you have been living under a rock for the last 17...

MySQL How INSERT() Function Works for MySQL

Journey to SQL Authority with Pinal Dave, July 12, 2014
Views: 15 | Hits

You know there is an INSERT statement which is used to add data to a table. But did you know that there is an INSERT function which will replace certain characters within a string? INSERT() function i...

SQL Server 2012 SP2 Slipstream ISO Flaw Causing Upgrade Issues

Microsoft Certified Professional Magazine Online | Todays Top Picks, July 11, 2014
Views: 10 | Hits

Problems with the ISO releases SQL Server 2012 Service Pack 2 have surfaced, according to Microsoft this week....

Calculating and Verifying Check Digits in T-SQL

Simple Talk, July 11, 2014
Views: 18 | Hits 2

A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes on data entry we must c...

Moving My Site to Azure: DNS & SSL

Marquee de Sells: Chriss insight outlet, July 11, 2014
Views: 11 | Hits

This part 3 of a multi-part series on taking a real-world web site (mine) written to be hosted on an ISP (securewebs.com) and moving it to the cloud (Azure). The first two parts talked about moving my...

SQL SERVER What is Biml and How Can it Help Me with SQL Server BI? Notes from the Field #036

Journey to SQL Authority with Pinal Dave, July 11, 2014
Views: 9 | Hits

[Note from Pinal]: This is a 36th episode of Notes from the Fieldseries.One of the common question I receive every other day is – I have learned BI but I feel that there is no automation in the BI fie...

Complex Jquery Datatable with Database State Saving & Basic Use of jQuery Templates with ASP.NET C# 4.5, Entity Framework

The Code Project Latest Articles, July 10, 2014
Views: 15 | Hits 1

Understanding of complex jQuery Datatable tricks and Save it's state in SQL Server with a basic concepts of jQyuery template. Sample Application used .NET 4.5, Entityt Framework....

SQL SERVER Round Up From Notes from the Field of Blog Posts of Tim Radney

Journey to SQL Authority with Pinal Dave, July 10, 2014
Views: 5 | Hits

We have completed 35 episodes of the series Notes from the Fields. I have been blogging for over 8 years and I have blogged about pretty much everything SQL and lots of other concepts. Though, I have ...

SQLAuthority News Two Whitepapers on Performance Tuning and Enhancements

Journey to SQL Authority with Pinal Dave, July 10, 2014
Views: 8 | Hits

The best part of being in the technology domain is that I get a lot of opportunity to talk and write at different places. I travel quite a bit in lengths to deliver some of my learnings with audiences...

SQL SERVER Documentation Tool

Journey to SQL Authority with Pinal Dave, July 9, 2014
Views: 11 | Hits 1

This article explains how to use ApexSQL Doc, a SQL documentation tool. You can download ApexSQL Doc, and follow along with this article. ApexSQL Doc is a SQL Server database development tool, for gen...

Setting up continuous integration for your database with Red Gate and AppVeyor

Simple Talk, July 8, 2014
Views: 12 | Hits 1

In this post Ill walk through setting up a hosted continuous integration (CI) system for your SQL Server database. Well be using AppVeyor, a cloud hosted CI system with a focus on easy setup for .NET ...

SQL SERVER Three Top Efficiency Features of Management Tool for SQL Server

Journey to SQL Authority with Pinal Dave, July 8, 2014
Views: 11 | Hits

Every weekend I spend time learning something new and interesting. My primary focus is always on either performance of SQL Server or performance of myself. This weekend, I downloadeddbForge Studio for...

SQL SERVER SSMS: Schema Change History Report

Journey to SQL Authority with Pinal Dave, July 7, 2014
Views: 23 | Hits 3

The heat is picking up and I am glad you are liking this series going so far. This particular report is close to my heart and the most recommended. At my recent trip to Delhi and the user group out th...

Moving My Site to Azure: The Database

Marquee de Sells: Chriss insight outlet, July 6, 2014
Views: 32 | Hits 10

In a world where the cloud is not longer the wave of the future, but the reality of the present, it seems pretty clear that its time to move sellsbrothers.com from my free ISP hosting (thanks securewe...

Developers Life Every Developer is Like Transformers

Journey to SQL Authority with Pinal Dave, July 6, 2014
Views: 30 | Hits 2

Transformers may not be superheroes they dont wear capes, they dont have amazing powers outside of their size and folding ability, theyre not even human (technically). Part of their enduring populari...

SQL SERVER Download SQL SERVER 2014 Database Engine Permission Posters

Journey to SQL Authority with Pinal Dave, July 5, 2014
Views: 21 | Hits 4

There is no better way to understand any complex subject than learning via diagrams. Security is very complex and dry subject. Not everyone understands it easily. I have seen quite a few of the develo...

SQL SERVER SSMS: Configuration Changes History

Journey to SQL Authority with Pinal Dave, July 4, 2014
Views: 31 | Hits 3

As we go through each of the reports available in SQL Server Management Studio, I have an anecdote to share almost for most of them actually. I have used them extensively at different times and I am g...

Using Sqlite in a Xamarin.Android Application Developed using Visual Studio

The Code Project Latest Articles, July 3, 2014
Views: 20 | Hits 3

Using Sqlite in a Xamarin.Android application developed using Visual Studio...

SQL SERVER Automate Database Operations for Success Notes from the Field #035

Journey to SQL Authority with Pinal Dave, July 3, 2014
Views: 29 | Hits 1

[Note from Pinal]: This is a 35th episode of Notes from the Fieldseries. Doing this faster and easier is always our goal. We all want to do thin which generates maximum return of investment with least...

SQL SERVER SSMS: Server Dashboard Report

Journey to SQL Authority with Pinal Dave, July 2, 2014
Views: 34 | Hits 3

The term dashboards come from the automobile world where it meant as instrumentation or controls for operating a vehicle. In the IT parlance, the use of dashboards meant as the state or health of syst...