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.
DRI or No DRI?
This editorial was originally published on Feb 19, 2006. We are reprinting pieces this week as Steve is traveling in the UK.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers