Latest Blog Posts
When importing data from a flat file using Power Query, you’d want to combine multiple files and include file name in the resulting table. For example, in Analyzing Baby Names using Power BI I posted recently, the file name contains year that I needed to include in the table. Here’s… Read more
In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re going to talk about database files settings and their autogrowth settings. From the first glance this seems to be an easy question. But in reality it may cause serious issues… Read more
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases.
Why is it important?
When you upgrade an application you just compile and…
The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance sessions by great speakers from all around the world.
I have the honor to speak in this year’s Performance Palooza, which will take place this Thursday, July 23.
I… Read more
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.
I created a login for an Azure SQL Database, but couldn’t log in. I would get this message, which makes perfect sense.
Just… Read more
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may… Read more
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks like:
- 1. sqlpackage.exe compares dacpac to database
- 2. sqlpackage.exe generates a deploy script
- 3. sqlpackage.exe runs pre-deployment script
- 4. sqlpackage.exe runs…
That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact, Microsoft is inviting you to the new SSMS coming out party.
I’m pretty excited about this. While I’m very comfortable in SSMS, to a large degree, it’s like that… Read more
I am honored to be speaking at the Edmonton SQL Server User Group. I always find it humbling to be asked to present and I thank the group for the opportunity. My travel budget will not allow for me to be onsite for this meeting, so this will be… Read more
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturday for the first time in many years. Then this weekend, I found out that I will also be delivering a full day Pre-Conference on Friday October 9, Transforming and Visualizing Data with Power… Read more
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes today and even though I haven’t been able to take part in all of them, I have thoroughly enjoyed working through these challenges.
DBAs don’t often get… Read more
While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:
Exclusive access could not be obtained because the database is in use.
Here is a quick solution which is much handier than killing all connections manually… Read more
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had to give them a shot and while I was somewhat disapointed in my scores on a few over all they were a lot of fun.… Read more
We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday. It started way back at #1 when we brought Joe Celko to town! It’s a way to give our local community the chance to do some deeper learning at a… Read more
What is SQL Server Polybase?
Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage. This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats… Read more
I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session resulted from feedback we received in the user group on differences between database developers and BI developers. If you are interested in seeing the presentation content it is uploaded here: Read more
When, I first saw this statement a Hindi proverb come to my mind which is “1 teer 2 nishane” . The meaning of this proverb means a single bow which hit two different aim in one shot.
So let me explain “Merge” statement in more detail. With the help of… Read more