PowerShell and Secure Strings
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
Using Big Data to Improve Health
With the help of a database that provides fully representative data, we can do a great deal more to advance medical and pharmaceutical science. Phil Factor explains what stands in our way.
Creating a PDF from a Stored Procedure in SQL Server
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
SQL Server Integration Services - The New ETL Paradigm
SQL Server 2005 will truly introduce a new paradigm in how developers and DBAs work with SQL Server. One area in which dramatic changes have taken place is DTS, which is now renamed to SQL Server Integration Services or SSIS. Expert author Jamie Thomson brings us a look at how the fundamentals of workflow change from DTS to SSIS.
Learn the fundamentals of Redgate Products
Redgate invite you to look around their newly refurbished University. If you are new to their tools there are simple, easy to follow courses to get you up and running, and if you are a long-time customer you can check out the recently added courses which take you through some more technical tips, tricks and troubleshooting
SQL Server Permissions List for Read and Write Access for all Databases
In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.
A Good Reason to use a VCS
Steve has a good reason to use a version control system. It's a different kind of backup that you might need.
PowerShell To Get Active Directory Users And Groups into SQL
Use Powershell to query AD for Users, Groups and GroupMembers
SQL Server Datetime vs. Datetime2
Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.
Understanding the OVER Clause in SQL Server
Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP KS Tubun Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jalan Letjen. S. Parman Kav. 28, L No.216-217, RT.12/RW.6, Tj. Duren Sel.,...
BCA KCP Rantai Mulia Kencana Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Pesanggrahan Jl. Puri Kencana No.28 29, RT.2/RW.7, Kembangan Sel., Kec. Kembangan,...
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers