Speeding up Data Access Part 1 - Missing Indexes
In the first part of this series, learn how to pinpoint missing indexes in your databases.
Being an extremely productive DBA
In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.
Database Size Survey
Help us collect some data on the sizes and counts of databases in your environment. Take a few minutes and answer this survey.
How Many Times Will This Happen?
This editorial was originally published on Jun 6, 2006. Steve is traveling in the UK this week and we are reprinting a few pieces. Today Steve talks about encryption on laptops.
JSON.SQL: A CLR-resident JSON serializer/deserializer for SQL Server
One CLR function and four CLR procedures for the import/export of JSON data to and from SQL Server are presented, with supporting performance metrics.
Migrating SQL Server Databases – The DBA’s Checklist (Part 1)
It is a fact of life: SQL Server databases change homes. They move from one instance to another, from one version to the next, from old servers to new ones. They move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released.
SQL Saturday #80 - Wheeling. WV
Come get a free day of SQL Server training in Wheeling on Jul 23, 2011.
Outsourced = Laid Off?
This editorial was originally published on May 3, 2006. Steve is traveling in the UK this week and we are reprinting older pieces. This one looks at offshoring.
Yet Another SQL Strategy for Versioned Data
There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is never deleted, but superseded by a later version. Whilst this is conceptually simple, it has always made reporting the latest version of data complicated. Alex Kuznetsov joins the debate on the best way of doing this with an example using an indexed view and the filtered index.
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