Searching for Plans
Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.
Automated Database Deployment Workshop: Belfast, Northern Ireland
Redgate's DLM Workshops are coming to Belfast, NI on June 26, 2015. Learn how to: deploy databases using Redgate's DLM tools, assess the different requirements of production and non-production deployments, and handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.
Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow
If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.
SQL Saturday #379 - South Florida
Join us for a free day of SQL Server training and networking in Davie, Florida on June 13, 2015. Admittance to this event is free, so register while space is available.
T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements
Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.
How to Get SQL Server Security Horribly Wrong
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.
Opening Up Data
Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.
The Case for Scalar-valued, User-defined Functions in T-SQL
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
How do you work with databases?
How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Supermal Karawaci telp/wa:083831618807
Whatsapp:083831618807 Lippo Karawaci, 105, Jl. Boulevard Diponegoro No.1200 FF #A 3A, Bencongan, Kecamatan Kelapa...
BCA KCU PANAKKUKANG. Tlp/wa:08218168235
By nha thiet ke thoi trang milanogoods
Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan 90231
BCA KCU GRESIK Hub:Cs.08216977726
Whatsapp:08216977726 Jl. Kartini No.98 B-100, Injen Barat, Tlogobendung, Kec. Gresik, Kabupaten Gresik, Jawa Timur...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers