Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
429 reads
Si vis pacem, para sql
Some stuff with Date and Time in SQL Server
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...
2017-05-09
1 reads
Some stuff with Date and Time in SQL Server
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...
2017-05-09
3 reads
Some stuff with Date and Time in SQL Server
I’m writing this post because I want to put some more stuff around dates and times in one place. I...
2017-05-09
1,038 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
9 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
1 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...
2017-05-10 (first published: 2017-04-29)
2,374 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of...
2017-04-08
24 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using a mixed extent for the first eight pages of...
2017-04-08
3 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using...
2017-04-08
5,584 reads
Blogs
Replacing Images in PBIR Format Reports
With the PBIR format of Power BI reports, it’s much easier to make report...
Capturing Ideas for Blogs
By Steve Jones
As we close out the year, I decided to drop this post here and...
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Forums
create multiple output files based on query
I have this script that puts all of the output from query to a...
what if my last resort on extracting excel is at the cell level?
Hi, after i copy in ssis my excel file to a secured folder, its...
dont see a file system task approach to copying excel
Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-and-move-to-a-new-location-using-ssis where content rather than file level...
Question of the Day
What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers