Power BI Workshop Videos
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this...
2015-01-29
669 reads
Blog Posts
SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,310 reads
SQL- Querying XML attributes from XML Column
Read XML column attributes in to two columns DimType and Dimvalue from the below example also retrieve the data matching...
2015-01-29 (first published: 2015-01-22)
38,550 reads
Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had encountered. Well, there were multiple problems. One was an...
2015-01-29
7 reads
Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had...
2015-01-29
1,331 reads
ASP.Net MVC File Stream, Initiated From Javascript Post
I was recently working on a page that does an AJAX post to an MVC controller passing quite a lot...
2015-01-28
268 reads
Excel BI Tip #17: Using the Timeline Filter
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-01-28 (first published: 2015-01-20)
6,924 reads
New Power BI Preview and Pricing
Some exciting announcements were made today about the new Power BI cloud-based business analytics service. Today Power BI is an...
2015-01-28
584 reads
Oh Look, A Horseless Carriage
Never forget, we’re making buggy whips. And everybody we know drives little buggies and they need our buggy whips. We’ve...
2015-01-28
1,083 reads
Out of Space
I’ve used placeholders to ensure I don’t run out of space on my machines. That’s worked well, and usually I...
2015-01-28
1,268 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Alamat BCA KCP Duta Mas Fatmawati Telp/Wa:0821-8200-233
Tlp/Wa:628218200233 Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1 No. 6,...
Alamat BCA KCP Hasanudin Telp/Wa:0821-8200-203
WA Cs:62 8218200203 Jl. Sultan Hasanuddin Dalam No.43/48, RT.2/RW.1, Melawai, Kec. Kby. Baru, Kota...
Alamat BCA KCP Kemang Telp/Wa:0821-8200-174
Telp/Wa:62 8218200174 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta Selatan,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers