SQLServerCentral Webinar #5 - Powershell and Source Control
MVP Allen White talked about how Powershell can be used to script out your database and put it in Source Control, and how SQL Source Control from
The DBA Disconnect
It seems that there is a disconnect between how technical people view security and how business people see it. Steve Jones talks about the problems that we have in trying to secure the systems we manage.
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
SQL Server Agent Job Management Scripts
In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.
Are You a Ten?
Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
Implementing SQL Server Database Mail
Have you ever wished your database could tell you what's wrong or let you know when a task has completed? SQL Server's Database Mail allows the database to send out messages over SMTP. Deanna Dicken shows you how to set up Database Mail and send some messages.
Google Scale
Not many of us work at Google scale, where every little thing you do can matter. However Steve Jones thinks that the little things still matter when you are building software.
TSQL Challenge 43 – Identifying incomplete segments and missing elemen
This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.
Capturing and Logging Data Load Errors for an SSIS Package
In an ETL solution, error logging is a fundamental requirement for various aspects of the application and is very useful at various stages of the ETL execution life-cycle. Let's consider a scenario where our requirement is to insert records into a SQL Server table. The package should attempt loading all the records and whichever records fail, error details reported by the database engine should be reported. We will look at how to implement this in a SSIS package.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU WAHID HASYIM No.Telpon 087781685647
Whatsapp 087781685647 Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan Tanah Abang,...
BCA KCU PONDOK INDAH No.Telpon 087781685647
Whatsapp 087781685647 Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...
BCA KCU SUDIRMAN No.Telpon 087781685647
Whatsapp 087781685647 Jl. Jenderal Sudirman No.21, RT.10/RW.1, Kuningan, Karet Kuningan, Kecamatan Setiabudi, Kota Jakarta...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers