(Pinal Dave) I cannot iterate this often, some of the best learnings always come from times you least expect a question to come from. Recently, when I was at a conference in Delhi, one of the attendees came to me to ask a question. The conversation was as below:

(Daniel Farina) In my previous tips (Introduction to Mainframe Data Storage for SSIS Developers and Importing Mainframe Data with SQL Server Integration Services) I introduced you to the mainframe world by explaining how to deal with zoned and packed decimal numbers and EBCDIC data when you need to

(Pinal Dave) The best way to learn something is to revisit some of the older blogs and then look at finding a more efficient way to work on the same problem. Recently I was looking at the forums to find a question come up again and again around making a comma separated list.

(Manvendra Singh) One of our SQL Servers was experiencing fatal errors on a frequent basis during batch processing. This was a SQL Server 2008 on Windows 2008 operating system. Here are some details of the error log which were captured:

(Ed Elliott) It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you may not want to give the user or process that does this sysadmin permissions just so that it can generate a deploy script. The per

(Daniel Mellor) Backups and restores are arguably the most important aspect of a DBA’s job. There are few times when a manager will be breathing down your neck more impatiently than during a restore process. Of course, one of the worst things you can say during such an event is, “I have no idea when

(dbafromthecold) So far in this blog series memory optimised tables have been created with the durability option of SCHEMA_ONLY meaning that data will not be retained. However there is another durability option of SCHEMA_AND_DATA which means that SQL will retain data held in memory optimised tables.

(Pinal Dave) I always get an opportunity to talk on topics that are basic from time to time. As I was preparing for GIDS 2015 (Great Indian Developer Summit) this year, I was vividly remembering one of the conversations I had with an attendee last year at our Pluralsight booth.

(Larry Leonard) Sometimes you run across a server that for one reason or another is full of MDF, NDF, and LDF files that look to be months or years old. Of course, you can’t go by the Date Modified timestamp of these files in Windows Explorer, but still, when you see a 300 GB file called “BOBS_TEST_

(derekewilson) Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement. You can use this to record what workstation the transaction came from in your application or business intelligence processes.