SQL Server 2012 enhanced the SQL Server 2008 FileStream data type by introducing FileTable, which lets an application integrate its storage and data management components to allow non-transactional access, and provide integrated SQL Server services. Arshad Ali explains how.
Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.
Level 2 of this stairway explains how to convert data declaration language (DDL) statements and data manipulation language (DML) statements from Postgres to Microsoft SQL Server.
What's the future for DBAs with cloud services and computing? Steve Jones talks about what might be coming soon.
While working with the Results to Text option in SSMS, you may come across a situation where the output from dynamically generated data is truncated. In this article I will guide you on how to fix this issue and print all the text for the Results to Text option.
Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.
Are you managing too much data? Lots of data professionals feel that way, but fortunately "Big Data" is in the news and bringing more visibility to the challenges we face on a daily basis.
As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?
One of the keys to better availability, scalability, and performance on your systems is understanding what is happening in the instances. That requires monitoring, which Steve Jones sees as essential.
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers