Using an ORDER BY in a view
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...
2016-09-26 (first published: 2016-09-19)
3,828 reads
Speaking at Suburban Chicago SQL Server Users Group Tomorrow
I will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users...
2016-09-19
363 reads
Building Oracle 12c on Linux 7 on Hyper-V
David has written a white paper, or short ebook titled building oracle 12C on Linux 7 VM residing on Hyper-V....
2016-09-19
460 reads
Books VS Internet
It’s is very easy to be
confused between investing in books or we should use the power of internet. If
you ask...
2016-09-19
235 reads
Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
385 reads
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM where I’ll be hosting a Birds of a Feather session “Moving to Independent Consulting” Bring your questions!*
Yes, an 8:00AM session in Las Vegas,...
2016-09-19
14 reads
5 Must Haves Before You Start Consulting
Please join me at IT/Dev Connections on Oct. 12 at 8:00AM* where I’ll be hosting a Birds of a Feather session “Moving to Independent...
2016-09-19
529 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)However, once the SQL instance is restarted this flag...
2016-09-19
148 reads
Azure IaaS Premium Storage Test
I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will...
2016-09-19
566 reads
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
DBCC TRACEON (1222,-1)
However, once the SQL instance is restarted this...
2016-09-26 (first published: 2016-09-19)
1,764 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCU Rawamangun Telp:0821-815-4374
Telp/WA +62 821-815-4374 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat BCA KCP Permata Ujung Menteng Tlp:0817-825-533
Telp/WA +62 817-825-533 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil,...
Alamat BCA KCP Matraman Telp:0821-755-5651
Telp/WA +62 821-755-5651 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers