Dejan Nakarada-Kordic


Dejan Nakarada-Kordic is a database specialist with ASB Bank in New Zealand. He was born in Yugoslavia in the 1970s and spent the 1990s in Zimbabwe before settling in New Zealand. He holds degrees in psychology and computer science, as well as many Microsoft certifications.

File Operations Made Easy
File operations that require many lines of T-SQL code can often be handled with a single function call if you use a CLR class, such as FileCLR. This class lets you easily obtain a list of the files in a folder, write text to a file, and much more.
Date Operations Made Easy
Although SQL Server 2008 corrected that shortcoming by introducing pure date and pure time data types, there are still a few tasks that are difficult to perform using T-SQL.
A Practical Approach to Managing Database Size
The size of a database's data files can affect database availability, performance, and support. Here's what you can do to effectively manage their size.
Move Database Files Without Taking the Database Offline
If you move database files using one the methods prescribed in the SQL Server documentation, you have to take your databases offline. You can avoid this situation by using the ALTER DATABASE and DBCC SHRINKFILE commands.
Managing Service Broker Conversations
Prevent data loss and improve performance by using this method to reduce conversation management overhead.
Don't Let Poison Messages Kill Processing in SQL Server 2005's Service Broker
Here's a solution you can use when you need to disable XML validation yet have Service Broker continue processing when it encounters a poison message.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Jul 17, 2017

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×