I know from my personal experience that many SQL Server novice users have issues while uploading and downloading data in various formats. In my practice, this kind of tasks arise very often. I would prefer to automate the process for the recurrent tasks, if the file structure is not going to be changed. I can create a SSIS package, deploy it on a server and then schedule one through the SQL Agent.
Interview Question of the Week #048 – How to Move TempDB to Another Drive?
In a recent interview when the interviewer asked interview that TempDB can be moved to a different drive, Â the candidate was extremely surprised. For the benefits of the interviewee who did not know the answer, I have written this blog post. Question: How to move TempDB to another drive? Answer:…
Read MoreSQL SERVER – Resource Governor and Database Mapping
Recently in my trip to US for SQLPass, I had a unique opportunity to meet a number of attendees for my session. The session was well received and I got some great feedbacks. I loved the recent trip and it was a great experience for me to learn and prepare…
Read MoreSQL SERVER – 2016 – Opening JSON with OPENJSON()
The first blog I wrote about JSON with SQL Server 2016 was to get a valid JSON output from relational tables. You can read that again from: SQL SERVER – Getting started and creating JSON using SQL Server 2016. In this blog, we will try to get to the next…
Read More
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error user receive when registering service principals. Ryan is one guy who spends more time with real world issues with SQL Server than anything else. He has mastered the art of resolving complex errors and document them so easily that one can’t find anywhere else. In this blog post Ryan addresses a very interesting error related to Service Principal Name. Read the experience of Ryan in her own words.
SQL SERVER – XEvents to Find Cardinality Estimation Issues
Ever since SQL Server 2014 brought the new Cardinality estimates, there have been a number of blogs to talk about them. Even here, I wrote a quite a few blogs about this very subject. SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation SQL SERVER –…
Read MoreSQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion
I am one of those fortunate people who has friends everywhere in the world. Syrovatchenko Sergey is one of my good friends who is an expert on SQL Server. When we met a few days ago in one of the event, we end up discussing about practical tips to reduce SQL Server database table size. Upon returning home, I found Sergey has sent me an amazing article on this subject. It is beautifully written article and I enjoyed it very much. Let us read what Sergey has to say about this subject in his own words.