Friday Reading 2017-07-14
Fun week, and what a Lions final test last weekend. Still can’t believe it!
Here’s what I’ve been reading…
STOPAT And Date...
2017-07-14
296 reads
SQL Server 2017 – DMV – sys.dm_os_host_info
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...
2017-07-27 (first published: 2017-07-14)
2,193 reads
My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
247 reads
No, Binary Collations are not Case-Sensitive
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,157 reads
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,638 reads
Point Counterpoint: Why Virtualize a SQL Server?
I get asked all the time – “why virtualize SQL Server if I’m content with my physical servers today?” The normal...
2017-07-24 (first published: 2017-07-12)
3,132 reads
LocalDB DSC Script
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
297 reads
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
164 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
125 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
458 reads
Blogs
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers