Dump Data From SQL 2005 table to Excel 2016
By First looking at the topic name, does the task sound simple to you? Well, I thought so but it...
2017-06-01 (first published: 2017-05-22)
1,431 reads
Blog Posts
SQL Server Dynamic Data Masking In Action
One of the new features SQL Server 2016 introduced is Dynamic Data Masking. This feature allows sensitive data to be...
2017-06-01
71 reads
SQLSaturday Pensacola and Houston
I have the honor of being selected to speak in Pensacola and Houston this month. Pensacola has been a great...
2017-06-01
579 reads
SQLSaturday Pensacola and Houston
I have the honor of being selected to speak in Pensacola and Houston this month. Pensacola has been a great place for SQLSaturday and it is no different than...
2017-06-01
8 reads
Deleting a Package from the SSIS Catalog
Among the new features of SSIS 2016, one of my favorite is incremental package deployment. This new functionality allows the...
2017-05-31
3,101 reads
Fischer’s Exact Test – with T-SQL and R
This post is a long overdue second part to the post on Chi Square Test that I did a few months...
2017-05-31 (first published: 2017-05-22)
1,479 reads
How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
393 reads
Implementing Fuzzy Sets in SQL Server, Part 10.2: Measuring Uncertainty in Evidence Theory
By Steve Bolton
…………To avoid overloading readers with too many concepts at once, I split my discussion of Dempster-Shafer Evidence...
2017-05-31
750 reads
SQL Server Parameter Sniffing In Depth
If you’ve ever searched for SQL Server parameter sniffing you’ve probably read all sorts of bad things about it. In...
2017-05-31
116 reads
Angular 2 FAQs
1. What is angular module?
NgModule helps to organize an application into organized blocks of functionality. @NgModule decorator takes metadata that...
2017-05-30
635 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers