How to configure SSL encryption in SQL Server
Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.
2014-08-19
11,226 reads
Articles
SQL Monitor Custom Metric: Out of memory errors
The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.
2014-08-19
8,708 reads
Automate Your Central Management Server Registrations
Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.
2014-08-18
5,656 reads
The Broad View
An ingenuous use of existing data leads to the thought - when are we so deep in our work that we can't see how to improve?
2014-08-18
44 reads
Common database deployment blockers and Continuous Delivery headaches
Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.
2014-08-18
10,398 reads
SQL Saturday #300 - Kansas City
SQL Saturday is coming to Kansas on September 13, 2014. Our very own Steve Jones will be presenting, alongside other big names like Glenn Berry, Kathi Kellenberger, Sean and Jen McCown, Jason Strate, and many more. Register while space is available.
2014-08-18
8,088 reads
From Hairdresser to DBA – How to start a career in IT
In writing about his career change from hairdresser to DBA, Greg Lucas shares his experiences and offers advice for those looking to move into IT.
2014-08-15 (first published: 2012-09-11)
16,983 reads
SQL Saturday #323 - Paris
On September 13, 2014 the French SQL Server Community (GUSS) will be holding a SQL Saturday conference. The event is free to attend, with 4 paid-for pre-conference sessions available. Register while space is available.
2014-08-15
7,687 reads
Why the SQL Server FORCESCAN hint exists
It is often generalized that seeks are better than scans in terms of retrieving data from SQL Server. The index hint FORCESCAN was recently introduced so that you could coerce the optimizer to perform a scan instead of a seek. Which might lead you to wonder: Why would I ever want a scan instead of a seek?
2014-08-15
8,926 reads
Restore Gene : Automating SQL Server Database Restores
Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.
2014-08-14
10,877 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Grogol Muwardi Tlpn/wa:085373737551
Jl. Dr. Muwardi I No.44, Grogol, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Jatinegara Timur,Telp/Wa 08213111159
Jl. Jatinegara Timur No.37 Pav, RT.8/RW.4, Bali Mester, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah...
BCA KCP Jelambar Baru Raya Telpon/WA:08218168291
BCA KCP Jelambar Baru Raya Telpon/WA:08218168291.Jl. Jelambar Baru Raya No.53 C, Jelambar, Kec. Grogol...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers