Protecting Data from the Inside
Phil Factor on the difficult task of guarding against the theft of data from within an organization.
Find SQL Server Installation Date for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.
More Network Restrictions
The rise of attacks is something Steve thinks will trigger more network protection, something data professionals will need to work with.
Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE
In this tip we look at how to read an Excel file from within SQL Server using OpenRowSet and OpenDataSource along with the possible errors you may encounter and how to fix these issues.
Experiment First
One skill that's useful to develop is the ability to learn things on your own. Often with a little help, but not too much.
Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code
In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.
Fragmented or Centralized Data
Is it better to copy and distribute data or centralize it? Steve has a few thoughts today.
Using a Surrogate vs Natural Key
A common debate in table architecture is whether to use a natural or surrogate key. In this article, I discuss some of the advantages to each method.
Database Tools and Extensions for Visual Studio 2019
In this article, you will explore tools and extensions that can be used with Visual Studio 2019 to improve your database experience irrespective of what database you use.
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 KCU THAMRIN. Tlp :085373737845
BCA KCU THAMRIN. Tlp :085373737845.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
BCA KCU GREEN GARDEN Tlpn/wa:085373737551
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
BCA KCP Kebon Sirih. Tlp:085373737845
BCA KCP Kebon Sirih. Tlp:085373737845.Jl. Kebon Sirih No.6A Lantai 1 B, Gambir, Kecamatan Gambir,...
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