Schema on Read vs Schema on Write
Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...
2014-09-12
1,212 reads
PASS Virtual Chapter Events: September & October 2014
PASS Virtual Chapter Events: September 2014
Join SQL Server professionals from around the world for free online technical training and networking...
2014-09-11
635 reads
SQL Server: Converting binary data to a hexadecimal string
Problem I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is it possible to directly convert the binary data...
2014-09-11
21 reads
SQL Server: Converting binary data to a hexadecimal string
Problem
I have a requirement to convert the binary data inside a table column or variable to a hexadecimal string. Is...
2014-09-11
4,692 reads
A Wonderful Weekend in Riyadh, Kingdom of Saudi Arabia, Speaking SQLGulf #1, Alfaisal University
Thanks to the perseverance of SQL MVP Shehap El-Nagar’s invite last year, this brave
man from the Saudi Ministry of Higher...
2014-09-11
1,561 reads
What are trace flags?
Trace flags are one of those things that I’ve heard about more and more over the last five or six...
2014-09-18 (first published: 2014-09-11)
7,958 reads
Identifying large queries using Server Side Traces
Who are your worst offenders? By offenders I mean, queries that are consuming the most resources on your server(s).
I know...
2014-09-17 (first published: 2014-09-11)
7,866 reads
SQL – List Primary key and Concatenate composite Keys into a single row separed by comma
The following query lists all the Primary keys of all the table.
OP has requested to list all PK and composite...
2014-09-16 (first published: 2014-09-10)
7,118 reads
VMworld 2014 Wrap Up for Data Professionals
A few weeks ago I was fortunate enough to attend VMware’s VMworld 2014 conference in San Francisco, CA. The show...
2014-09-10
494 reads
September 2014 Las Vegas UG Meeting
Who is up for a little free learning this week? Besides the opulence and feast that was the 24 Hours of PASS (Summit Preview), we have more training in...
2014-09-10
4 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers