Back with a new focus
First let me say wow can’t believe that it has been almost 3 years since I have blogged. The last few years my career have been focused on transitioning...
2019-05-19
14 reads
Another SQL Geek
SQL 2016 SSIS new feature AutoAdjustBufferSize
If you have not already seen in the What’s New in Integration Services list there is a new property for...
2016-07-21
1,729 reads
Use PowerShell to automate your Azure DB creation
Why create your databases manually if you don’t have to? If there is one thing that I hate to do...
2016-07-20
839 reads
Update to Date and Time Dimensions
Wanted to just post my latest versions of my Date and Time Dimension scripts. It has been a couple years...
2016-05-09
389 reads
Power BI Embedded is here
The announcement of Power BI Embedded came last week during Microsoft’s Build Conference and now enables software vendors or anyone...
2016-04-05
566 reads
SQL Developer Edition is now free!!!
Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...
2016-04-01
814 reads
Power BI and Google Analytics
One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...
2016-01-20
1,298 reads
Power BI Export Data
If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...
2016-01-22 (first published: 2016-01-13)
2,247 reads
Viewpoints from CES 2016
While I never really enjoy a cross country flight back home my feet are very happy that I am finally...
2016-01-11
323 reads
Be an Expert not an Ehhpert!!!
As we embark on a new year I decided to take a look back at my career within I.T. trying...
2016-01-12 (first published: 2016-01-06)
2,236 reads
Blogs
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Forums
Change Tracking Default Retention
Comments posted to this topic are about the item Change Tracking Default Retention
ssrs subscription file share
I am trying to create a subscription that posts to a one drive directory. ...
What is Delayed Durability in SQL Server — And Should You Turn It On?
Comments posted to this topic are about the item What is Delayed Durability in...
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers