Due Diligence
How can you perform due diligence on new employees? There are a variety of ways, but Steve Jones has an idea that might help you nudge a potential employer in the direction you want them to move.
Open Call for Editorials
Steve Jones is putting out an open call for guest editorial pieces in the spring of 2014. If you're interested, read on.
Partitioning Data in a Multi-tenant Data Warehouse Solution
Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.
Microsoft Azure SQL Database Security - Firewall Configuration
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.
Automating Database Restores
This article describes a way to automatically restore multiple database backups from a directory.
Consolidation Matters
Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.
Monitoring SQL Server: An Interview with David Bick
Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.
SQL Saturday #305: Dallas, BA Edition
Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available
Unexpected View Performance
Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.
SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.
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 RAWAMANGUN No.Telpon 087781685647
Whatsapp 087781685647 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
BCA KCP Kas Mojoroto No Tlp 083831618816
WhatsApp:083831618816 Jl. Jaksa Agung Suprapto No.20, Mojoroto, Kec. Mojoroto, Kota Kediri, Jawa Timur 64112
BCA KCU PANGERAN JAYAKARTA No. telp:087757645171
Whatsapp:087757645171 Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan Sawah Besar, Kota...
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