Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Can I calculate the number of rows in a SQL Distributed Management Objects (SQL-DMO) bulk copy data file without importing the data?
I don't know a way to use SQL-DMO to calculate the number of rows in a data file. But all you need to do is co...
Periodically, when I try to open a database, I get the error message Log file is full. Cannot open database. After I truncate the transaction log, I can open the database. The problem occurs with some databases and not others. Why is this...
Have you applied the latest SQL Server security patch? And how can you stay on top of all the security fixes coming down the pike from Microsoft and other sources? Security is an important topic in IT regardless of which technologies you...
Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, which I wrote about in my SQL Server Magazine UPDATE article "Participate in the SQL Server Playback Program!" (which is available...
Congratulations to Peter Lin, software engineer at Energistic in Port Klang, Malaysia, and Walid Rifai, software developer for Engineering Design and Manufacturing in Beirut, Lebanon. Peter won first prize of $100 for the best solution to the May...