|
|
|
|
Latest Blog Posts
-
|
As noted in my previous post , I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table, but then replace them without having to save off the script...
|
-
|
Sharing with the community why we decided to move back from ElasticSearch to SQL Server Sometimes it happens: you move to something that is considered cool and bleeding edge back to something that has dust over it. Well, at least this is how SQL Server...
|
-
|
I am working on improvements to my SQL ExecStats tool, including Azure support. Previously, I had put try catch blocks around everything that bombs in Azure. Now I am putting IF EXISTS tests around SQL referencing system views and procedures not in Azure...
|
-
|
Azure Cosmos DB is Microsoft’s new global scale, distributed database as a service that supersedes Azure Document DB. Cosmos is a technology that enables you to create applications that are unimaginable with a single conventional relational database,...
|
-
|
While preparing blog posts last week, the following message appeared in my browser window. I was in the Azure portal when the message appeared. It’s not an error with Azure or the browser. It could happen when using any website or browser. I tried again...
|
-
|
Today at the Preakness horse racing event, Classic Empire dominated and led the race appearing to be the certain winner with Always Dreaming staying a close second and appearing to be a possible contender. At the end, Cloud Computing charged ahead leaving...
|
-
|
Azure uses Role Based Access Control (RBAC), which is something people generally don’t pay at lot of attention to when initially learning how to use the Azure portal. Take a close look at the screen capture shown below. The Delete button is disabled....
|
-
|
Microsoft has released the following Cumulative Updates for SQL Server 2016 (RTM and SP1). Cumulative Update 6 for SQL Server 2016 RTM KB 4019914 Download Build number: 13.0.2204.0 SQL Release Services Blog post Cumulative Update 3 for SQL Server 2016...
|
-
|
As I wrote in Parsing SSIS Catalog Messages for Lookup Performance, v2 : I prefer to passively gather performance metrics – even if it’s a little convoluted and more work (for me). I don’t often need these metrics immediately available, so I execute queries...
|
-
|
People new to Power BI Desktop have asked me how to create a columnar chart where each column has different colors for different values stacked on top of each other. There’s no reason to be intimidated. Creating such a chart is very simple with only two...
|
-
|
When I worked for Microsoft giving presentations on data platform products, it was a common occurrence to have people tell me that they didn’t know how to use Power BI. This is the first in a series of posts showing how to do simple, useful tasks in Power...
|
-
|
I am honored to present Use Biml to Automate SSIS Design Patterns at SQL Saturday 620 – Dublin 17 Jun! Abstract Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally,...
|
-
|
People often ask me about learning how to use Azure SQL Database as well as many other Azure products. If you want to learn, you’ve got to have an Azure account. Get one for free or use your personal or corporate MSDN account. Where I see people struggling...
|
-
|
I am honored to present my day-long precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration at SQL Saturday 620 – Dublin 15 Jun 2017! Description What is Intelligent Data Integration? SSIS packages developed using tried and...
|
-
|
The sessions of the event 24 Hours of PASS Data Security and Data Quality edition (held the last May 2017 on 3rd and 4th) were recorded and now they are available for online streaming! If you have missed one session in particular or the entire event,...
|
-
|
I’m writing about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages in their enterprises. Earlier I wrote Schedule an SSIS Application with SSIS Framework Community...
|
-
|
I’m writing more about SSIS Framework Community Edition because lots of people are using this free, open-source utility to execute collections of SSIS packages – called SSIS Applications – in their enterprises. Earlier I wrote Schedule an SSIS Application...
|
-
|
The coolest thing about SSIS Framework Community Edition is it’s free . You can click that link to head over to the DILM Suite site where you can learn more and find a link to the source code, documentation, and sample SSIS projects on GitHub. I’m overwhelmed...
|
-
|
Hearing this is one of those things that really bugs me. And it’s not actually about stored procedures, it’s about the mindset that sits there. I hear this sentiment in environments where there are multiple developers. Where they’re using source control...
|
-
|
I am in the middle of building a utility (for work, and for my next SQLBLOG post), that will help when you need to drop the foreign key constraints on a table, but then replace them without having to save off the script manually. Part of the process is...
|
-
|
In the last few years, I and Alberto Ferrari assisted many users of Power Pivot and Power BI who wanted to create their reports using these tools and were struggling with getting the desired numbers from their data. The first approach of an Excel user...
|
-
|
Hi Folks, We've just created the May 2017 update for SDU Tools. We're pretty excited about what we're delivering this month. The first part that we’ve added is a set of tools to make it really, really easy to capture a performance query trace, to load...
|
-
|
I’m honored to present Use Biml as an SSIS Design Patterns Engine at SQL Saturday #588 in New York City 20 May 2017! I’ve been looking at the event schedule and… WOW! There are a lot of smart people presenting – plus me ! I hope to see you there. :{>...
|
-
|
This post is a follow-up to Mind the Gap where I wrote about Δ, the difference between our perception of ourselves and other’s perception of us. In Mind the Gap I focused on personal and community ramifications of minimizing your Δ. In this post I write...
|
-
|
On May 25th the PASS Application Development Virtual Group will host a new webinar delivered by the well know Dejan Sarka and the topic will be R ( https://www.r-project.org/ ) that is more and more used also by developers: Introducing R R is a free software...
|
|
|
|
|
|