Perhaps I should just rename this blog to My SQL Blog. I haven’t done any real programming entries in here in what seems like years. Anyway, here is the latest tidbit that I thought I’d drop in here for my future reference. 188 more words
Tags » Microsoft SQL Server
I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing the ETL Pipeline
We’re going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. 109 more words
I assume that reader of this post has some basic knowledge of PowerShell script and its environment setup.
Some days ago by boss asked me combine power of SQL and PowerShell. 148 more words
when designing tables and there relationship in a database, i like to use database diagrams to define foreign key relationship. but if its only shows the column name than some time its difficult to assign foreign key relationship. 165 more words