News in the Category:
SQL 
Total posts: 7701 | Sort by Views | Sort by Hits
Journey to SQL Authority with Pinal Dave, October 17, 2016
Views: 52 | Hits
I love connecting community via various channels. One of my clients explained an interesting issue to me. He explained that he has a production database which is going to Recovery Pending state by its...
Journey to SQL Authority with Pinal Dave, October 16, 2016
Views: 47 | Hits 1
If you are a DBA for quite some time, then at least once you must have encountered below error about Domain Account Password.Error 1069: The service did not start due to a logon failure. I have alread...
Journey to SQL Authority with Pinal Dave, October 15, 2016
Views: 70 | Hits 1
Recently I was consulting a customer and they had plans to change certificate used by SQL Server. After making changes to certificate, we found that we were not able to start the SQL Server Service. L...
Journey to SQL Authority with Pinal Dave, October 14, 2016
Views: 96 | Hits 8
Have you ever got into a situation wherein you feel you see something and work for a solution in a completely opposite direction? Recently I was out of the country for a session and at the breakfast t...
Journey to SQL Authority with Pinal Dave, October 13, 2016
Views: 95 | Hits 3
As you might know I try hard to help the community via various channels. Comment on my blog is one of that channels. Here is a blog post which talks about error about Unauthorized Operation.First appe...
Journey to SQL Authority with Pinal Dave, October 12, 2016
Views: 111 | Hits
While writing my earlier blog, I broke a few settings and started getting new errors. Earlier, when I used to run below command, it used to work fine. However, just a day ago, it has given me error re...
Journey to SQL Authority with Pinal Dave, October 11, 2016
Views: 114 | Hits 4
I have written a number of blogs around working with SPARSE Columns in the past and a primer to what SPARSE Columns can be got from the list mentioned:First appeared on SQL SERVER – Performance Benefi...
Journey to SQL Authority with Pinal Dave, October 10, 2016
Views: 97 | Hits
I break a lot of things on my SQL environment and I believe that is a very good way to learn things. Today, I wanted to perform a restore of a database using a backup which I took earlier. In this blo...
Journey to SQL Authority with Pinal Dave, October 9, 2016
Views: 134 | Hits 4
Question: What is a Backup Timeline for Restore Process?Answer: One of the most popular interview question about Backup and Restore Database process.First appeared on What is a Backup Timeline for Res...
Journey to SQL Authority with Pinal Dave, October 8, 2016
Views: 124 | Hits
In the recent past, I have heard this issue, at least once or twice every month. Whenever I try to help a such client and I think I know the issue, I get something new. They said that they have applie...
Journey to SQL Authority with Pinal Dave, October 7, 2016
Views: 120 | Hits 2
Working with SQL Server is fun. Since SQL Clustering, and AlwaysOn availability group needs Windows Clustering so sometimes there are some cluster issues which I have to deal with and fix. Let us lear...
The Code Project Latest Articles, October 6, 2016
Views: 92 | Hits 4
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction....
Journey to SQL Authority with Pinal Dave, October 6, 2016
Views: 92 | Hits
I have been writing a lot of my findings with SQL Server 2016 in the recent past. This is also being something I have been investing big time keeping my session at SQLPASS coming in the October timefr...
Simple Talk, October 5, 2016
Views: 80 | Hits 7
The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out Who the devil wrote t...
Journey to SQL Authority with Pinal Dave, October 5, 2016
Views: 81 | Hits
Just earlier today, I have learned fantastic news about new branding for my favorite SQL Server vendor SQLSentry, which is not SentryOne. The new name and new branding truly reflects the organization ...
Journey to SQL Authority with Pinal Dave, October 5, 2016
Views: 88 | Hits 1
Since my consulting have started around performance tuning, I am able to see a number of customers who want to start using the new capabilities of SQL Server for their existing application as they pla...
Simple Talk, October 4, 2016
Views: 91 | Hits 8
You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edi...
Journey to SQL Authority with Pinal Dave, October 4, 2016
Views: 119 | Hits 6
We talk a lot about optimizing SQL with building the most efficient queries and application architectures. Its what we enjoy doing and what were paid to do. We love to twiddle bits and tweak code, and...
Journey to SQL Authority with Pinal Dave, October 3, 2016
Views: 99 | Hits
For my upcoming training, I was trying to deploy SQL Server 2008 R2 Cluster in my clients lab machines. I encountered a strange error and I was clueless. Let us learn about Rule Windows Server 2003 FI...
Journey to SQL Authority with Pinal Dave, October 2, 2016
Views: 104 | Hits 6
Question: How to Introduce Time Delay Between Two TSQL Commands?First appeared on How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091...
Journey to SQL Authority with Pinal Dave, October 1, 2016
Views: 105 | Hits
I have written a number of PowerShell script in the blog and they have been used by many. Most of these scripts are there because someone wanted something different and I got about creating something ...
Journey to SQL Authority with Pinal Dave, September 30, 2016
Views: 135 | Hits 4
I was recently asked if I know the fastest way to export data from SQL Server table. This was very interesting question personally, as I have not run any such tests in the past. However, everytime whe...
Journey to SQL Authority with Pinal Dave, September 29, 2016
Views: 109 | Hits 4
Yesterday when I wrote about what I learnt from Vinods session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tri...
Frans Boumas blog, September 28, 2016
Views: 115 | Hits 4
Today we released the second Early Access Program (EAP) build of LLBLGen Pro v5.1! Please see the previous post on the first EAP build and whats included in that version. This version builds further o...
Journey to SQL Authority with Pinal Dave, September 28, 2016
Views: 125 | Hits 4
I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me ...
Journey to SQL Authority with Pinal Dave, September 27, 2016
Views: 124 | Hits 2
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...
Journey to SQL Authority with Pinal Dave, September 26, 2016
Views: 129 | 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...
Journey to SQL Authority with Pinal Dave, September 25, 2016
Views: 139 | 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...
Journey to SQL Authority with Pinal Dave, September 24, 2016
Views: 140 | 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...
The Code Project Latest Articles, September 23, 2016
Views: 167 | Hits 8
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....
Journey to SQL Authority with Pinal Dave, September 23, 2016
Views: 135 | Hits 3
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...
Journey to SQL Authority with Pinal Dave, September 22, 2016
Views: 140 | Hits 5
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...
Journey to SQL Authority with Pinal Dave, September 21, 2016
Views: 121 | 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 ...
Simple Talk, September 20, 2016
Views: 103 | 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...
Simple Talk, September 20, 2016
Views: 113 | Hits 5
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 ...
Journey to SQL Authority with Pinal Dave, September 20, 2016
Views: 111 | 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...
Journey to SQL Authority with Pinal Dave, September 19, 2016
Views: 107 | 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...
Journey to SQL Authority with Pinal Dave, September 18, 2016
Views: 136 | 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...
Journey to SQL Authority with Pinal Dave, September 17, 2016
Views: 143 | 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...
Simple Talk, September 16, 2016
Views: 149 | 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...
Simple Talk, September 16, 2016
Views: 175 | 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...
Simple Talk, September 16, 2016
Views: 150 | 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 ...
Journey to SQL Authority with Pinal Dave, September 16, 2016
Views: 143 | 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...
Journey to SQL Authority with Pinal Dave, September 15, 2016
Views: 156 | 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 ...
Journey to SQL Authority with Pinal Dave, September 14, 2016
Views: 130 | 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...
Journey to SQL Authority with Pinal Dave, September 13, 2016
Views: 142 | Hits 2
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...
The Code Project Latest Articles, September 12, 2016
Views: 107 | 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...
Journey to SQL Authority with Pinal Dave, September 12, 2016
Views: 107 | 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...
Journey to SQL Authority with Pinal Dave, September 11, 2016
Views: 127 | 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...
Journey to SQL Authority with Pinal Dave, September 10, 2016
Views: 151 | 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...