Get the all the SQL Server related services information
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,281 reads
Scripts
2008-11-25 (first published: 2008-10-20)
1,334 reads
AUTOGENERATE Stored procedures example
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
762 reads
AUTOGENERATE INSERT UPDATE SELECT STATEMENTS
use metadata to generate basic create procedure statements for insert update and select
2008-11-21 (first published: 2008-10-10)
3,848 reads
2008-11-20 (first published: 2008-10-06)
990 reads
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
297 reads
Queries, Plans, and Indexes
Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.
2008-11-18 (first published: 2008-07-31)
1,719 reads
Backup And Restore Remain Time
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,068 reads
Data extrapolation on the fly
Sometimes we need to generate the data based on a given date, to an end date (data extrapolation).
This is a easy way to do that without any temporary storage.
2008-11-14 (first published: 2008-09-25)
919 reads
Display SQL services information
This Script is used to display the SQL and windows services information
by using the Windows Management Instrumentation Command-line (WMIC),
2008-11-11 (first published: 2008-09-20)
1,391 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