News in the Category:
SQL 
Total posts: 7763 | Sort by Views | Sort by Hits
Journey to SQL Authority with Pinal Dave, November 28, 2016
Views: 41 | Hits 2
The era of innovation with SQL Server administration side of things keep happening, it is strange that a lot of us miss these capabilities getting added into the system. I have seen processes define t...
Journey to SQL Authority with Pinal Dave, November 27, 2016
Views: 60 | Hits 3
Question: How to downgrade from SQL Server 2014 to SQL Server 2012?Answer: Not possible.First appeared on How to Downgrade Database from SQL Server 2014 to SQL Server 2012 – Interview Question of the ...
Journey to SQL Authority with Pinal Dave, November 26, 2016
Views: 139 | Hits 3
Just the other day I got an email with user asking how do the @@idle function work with SQL Server as when he runs them it gives him some number but the number is not easy to interpret. I totally agre...
Journey to SQL Authority with Pinal Dave, November 25, 2016
Views: 67 | Hits
Received an email "Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our sysmail_mailitems table. We are also facing performance issues." I have been an ...
Journey to SQL Authority with Pinal Dave, November 24, 2016
Views: 86 | Hits 1
When I visit my client site for doing performance tuning consulting, I sometimes get trapped with some unrelated issue. Here is one of the situation where they were upgrading from SQL 2008 R2 to SQL 2...
Journey to SQL Authority with Pinal Dave, November 23, 2016
Views: 86 | Hits
One of my clients reported a strange problem and I learned something new from it. Here is the conversation where we discussed how to fix error 19062 - could not create a trace file. First appeared on ...
Frans Boumas blog, November 22, 2016
Views: 102 | Hits 4
After 2 successful EAPs and a beta, were happy to release the RTM version of LLBLGen Pro v5.1! To see whats new in detail please see the blogposts about EAP1, EAP2, and the Beta. In short: Entity Fr...
Journey to SQL Authority with Pinal Dave, November 22, 2016
Views: 96 | Hits 1
Have you ever seen a situation where SQL Server mirroring is impacted because of external factors? One of my customers reported several of the following errors in the SQL Server ERRORLOG SQL SERVER W...
Simple Talk, November 21, 2016
Views: 102 | Hits 4
Are we now seeing just a frisson of excitement amongst database professionals at the potential of virtualization, and containerization technologies? I read with interest Andrew Pruski’s recent post on...
Journey to SQL Authority with Pinal Dave, November 21, 2016
Views: 105 | Hits 5
One of my clients posted a question to me about management of SQL Server service account. Since it was a nice learning for me, I am sharing my discussion via this blog post. Let us see the Best Practi...
Journey to SQL Authority with Pinal Dave, November 20, 2016
Views: 102 | Hits 8
Question: How to find the longest running query in SQL Server with Execution Plan? First appeared on How to Find Longest Running Query With Execution Plan – Interview Question of the Week #098...
Journey to SQL Authority with Pinal Dave, November 19, 2016
Views: 108 | Hits 1
When you want to be successful, you need to run alone and fast. But if you want to run longer, you want to run together. I have personally seen multiple instances where this statement holds true to ev...
Simple Talk, November 18, 2016
Views: 108 | Hits 3
Database Lifecycle Management (DLM) aims to provide a roadmap of of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How does the...
Journey to SQL Authority with Pinal Dave, November 18, 2016
Views: 103 | Hits 1
Recently I was at a community session talking to a bunch of computer science students about databases and the type of work I have been doing lately in consulting. I wanted to talk about Performance tu...
Journey to SQL Authority with Pinal Dave, November 17, 2016
Views: 108 | Hits 3
Earlier this year, I presented at SQLPASS 2016, Seattle on SQL Server 2016 and I am very happy to see the feedback of my sessions. I have presented two sessions and I will write feedback of one sessio...
Journey to SQL Authority with Pinal Dave, November 16, 2016
Views: 112 | Hits 3
Microsoft has earlier released SQL Server 2016 Service Pack 1 (SP1). This particular SP1 is one of the kind service pack and I will say it is a milestone move by Microsoft.Now with this SQL Server 201...
Simple Talk, November 16, 2016
Views: 104 | Hits 10
You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes an...
Journey to SQL Authority with Pinal Dave, November 16, 2016
Views: 90 | Hits
When it rains, it pours. In the last few days last few contacts from my customers were for cluster related issues. Once again, the SQL Server resource was not coming online in failover cluster manager...
Journey to SQL Authority with Pinal Dave, November 15, 2016
Views: 99 | Hits 5
SQL Server Analysis Services (SSAS) is becoming increasingly popular as an OLAP platform for business analysts. There are many tools available for enhancing the analysts ability to process data and ge...
The Code Project Latest Articles, November 14, 2016
Views: 106 | Hits 5
A quick demo tutorial on how to setup .NET Core on Mac and creating a simple ASP.NET Core app that talks to PostgreSQL database, and running it on Docker....
Journey to SQL Authority with Pinal Dave, November 14, 2016
Views: 79 | Hits 4
Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This b...
Journey to SQL Authority with Pinal Dave, November 13, 2016
Views: 85 | Hits 5
Question: How to Find Size of All the Indexes on the Database?First appeared on How to Find Size of All the Indexes on the Database – Interview Question of the Week #097...
Journey to SQL Authority with Pinal Dave, November 12, 2016
Views: 93 | Hits 4
There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.First appeared on SQL SERVER – How to Get List o...
Journey to SQL Authority with Pinal Dave, November 11, 2016
Views: 108 | Hits 7
When I wrote the blog around Understanding Database Scalability Vertical and Horizontal, I saw few have conversations with me on if it is this or that. And these discussions could take a course all b...
Journey to SQL Authority with Pinal Dave, November 10, 2016
Views: 105 | Hits 1
One of my blog readers reported a strange issue to me. As per the issue described, they were unable to bring SQL Server resource in cluster online, only on one node of the cluster. I always use for er...
Journey to SQL Authority with Pinal Dave, November 9, 2016
Views: 110 | Hits 1
The cloud phenomenon is no more a dream for many, but a reality for several customers I have been working with. Many of my customers are looking for guidance and from time to time I get an opportunity...
Journey to SQL Authority with Pinal Dave, November 8, 2016
Views: 125 | Hits 1
Almost all the time, whenever there is a wizard, its a human habit to go with the defaults and finally click finish. Once of my client sent below email to me. In this blog post we are going to learn a...
Journey to SQL Authority with Pinal Dave, November 7, 2016
Views: 127 | Hits 1
Whenever I write something as a new concept, I do see people reading the blog do give it a try. Many a times I get queries that the script didnt work for them after they learnt the concepts about memo...
Journey to SQL Authority with Pinal Dave, November 6, 2016
Views: 133 | Hits 10
Question: How Many Foreign Key Can You Have on A Single Table?I was asked above question in my recent SQLPASS presentations. I quickly answered that it is 253. However, after I returned home when I se...
Journey to SQL Authority with Pinal Dave, November 5, 2016
Views: 121 | Hits 2
Freelancing gives me a lot of opportunity to see issues which I have not seen earlier. Learning never stops for me and I love sharing what I learn every day. Let us learn about how to fix the error Pr...
Simple Talk, November 4, 2016
Views: 131 | Hits 4
Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements fo...
Simple Talk, November 4, 2016
Views: 120 | Hits 10
It is far easier to work out what is wrong with a slow-running SQL query than one that shows erratic performance. DBAs will groan when a process occasionally performs terribly without apparent reason....
Journey to SQL Authority with Pinal Dave, November 4, 2016
Views: 122 | Hits 1
Once I was in a situation where there was a disaster faced by my client. They lost the drive which was having transaction log file. Since they did not have effective monitoring, they realized that the...
Simple Talk, November 3, 2016
Views: 122 | Hits 6
When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfam...
Code Climber, November 3, 2016
Views: 114 | Hits 8
Monday morning (USA time) 31st October 2016, at a certain point my post about Surface Book vs MacBook Pro got the first position on Hacker News. It triggered a good amount of discussion, and luckly th...
Journey to SQL Authority with Pinal Dave, November 3, 2016
Views: 108 | Hits 1
When SQL Server 2016 was released, there were a number of enhancements that were discussed around how InMemory OLTP removed which were as limitations. I personally saw some real boot to some of the ca...
Journey to SQL Authority with Pinal Dave, November 2, 2016
Views: 119 | Hits 5
We are all hard wired when it comes to doing certain tasks. I have attended tons of sessions at the local SQL Server user group meets and it amazes me every time to what I didnt know about the tools t...
Journey to SQL Authority with Pinal Dave, November 1, 2016
Views: 122 | Hits 2
10 years ago, today I started to blog, at http://blog.sqlauthority.com - I had no idea where this journey will bring me. I honestly had no idea. Lots of people ask me so many questions about blog so t...
Journey to SQL Authority with Pinal Dave, November 1, 2016
Views: 124 | Hits 2
Here is one of email which I received from one of my clients where he mentioned that he was unable to bring SQL Online.Pinal,I need assistance in getting the failed SQL Server resource online on the n...
Journey to SQL Authority with Pinal Dave, October 31, 2016
Views: 120 | Hits 1
There are many DBAs who create jobs in SQL Server to recycle ERRORLOG files every midnight. They also increase the files from 6 to a bigger number so that they have data for more than 6 days.First app...
Journey to SQL Authority with Pinal Dave, October 29, 2016
Views: 157 | Hits 2
This was one of the interesting issues I solved in many days. One of my clients contacted me and told that they have scheduled a maintenance plan to take t-log backup at 10 PM but its not running. Whe...
Journey to SQL Authority with Pinal Dave, October 28, 2016
Views: 180 | Hits 5
Yesterday I started my day early to get to a gym. I know this was the first day and I had loads of work pending to be completed at work too. This got me busy and I started to drive my car, oblivious o...
Simple Talk, October 27, 2016
Views: 132 | Hits 3
Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have onl...
Simple Talk, October 27, 2016
Views: 136 | Hits 6
Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have onl...
Journey to SQL Authority with Pinal Dave, October 27, 2016
Views: 160 | Hits 2
With SQL Server 2016, I have come to know some of the restrictions which were applicable earlier are no longer the limits to look for. In one such experimentation is what I stumbled upon the blog post...
Simple Talk, October 26, 2016
Views: 126 | Hits 6
In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made mor...
Journey to SQL Authority with Pinal Dave, October 26, 2016
Views: 132 | Hits 2
Sometimes you need to know more about permissions on file, service account etc. to fix certain errors. In my recent visit to a customer location, one of the database developers came to me with a probl...
Journey to SQL Authority with Pinal Dave, October 25, 2016
Views: 105 | Hits 6
Recently I was troubleshooting at a customer location something that looked trivial. When the customer approached me for a consulting requirement wherein they were saying their system was going unresp...
Journey to SQL Authority with Pinal Dave, October 24, 2016
Views: 120 | Hits 3
I always like to keep a number of scripts handy in my USB drive with my Laptop. These scripts are used for my internal use when I am suddenly looking for something interesting in customer environments...
Journey to SQL Authority with Pinal Dave, October 23, 2016
Views: 181 | Hits 8
A very common question I often see users not sure about the answer. This is indeed a tricky question, but a very simple one. If I am the interviewer, I may ask this question to the user, but if they d...