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,701 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
819 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
386 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
563 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
808 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,295 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,234 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
321 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,235 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers