The Microsoft SQL Server Team has recently posted about one of the really exciting enhancements to SQL Server 2019 – Big Data Clusters
You are browsing archives for
Tag: Microsoft SQL Server
SQL Server User Group [Sydney] – Reducing the Risk of Data Breach and Improving Data Security – Tue 10th Sep 2019
Tue., 10 Sep. 2019, 5:30 pm: So I assume the session title got your attention… Good! As databases get larger and organisations retain more data for business intelligence / data analytics purposes the — Read on www.meetup.com/en-AU/Sydney-SQL-Server-User-Group/events/261421144/
SQL Server Engineering Team – New Website for Important SQL Server Info + Updates
A new home for the SQL Server engineering team to communicate important information about SQL Server with the community. We have migrated several SQL Server related blogs to this new home in the SQL Server TechCommunity. Click here for the new SQL Server Engineering Team blog. There’s also a list of links to some of their […]
Get free technical eBooks on SQL Server 2017 from Microsoft
Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]
Tonight: SQL Server User Group Sydney – The Roadmap for SQL Server
Sydney SQL Server User Group meets tonight from 5:30pm at Microsoft Reactor. Tonight’s Speaker: Victor Isakov (MCA, MCM, MCT, MVP) More details here. Tonight will cover: With support for Linux and Containers SQL Server 2017 opened up a new world of possibilities for Microsoft. SQL Server 2019 will bring to market a new modern data […]
SQL Server on Linux: A guide to re-platforming and modernizing your data workloads
SQL Server Table Function Performance
Rob Farley has a great post on when is a SQL function not a function? Read the two below functions – they return the same thing, but one is more effecient than the other. If you can’t see why, head over to Rob’s post that shows the execution plans for a great explaination. CREATE FUNCTION dbo.FetchSales_inline(@salespersonid […]
Updated SQL Server 2005 Books Online (help) Available Now (Feb 2007)
As SQL Server 2005 continues to grow and change, the Books Online / help files are also updated. Keep your help files up-to-date by downloading the latest copy. Download SQL Server 2005 Books Online Feb 2007 version.
Capturing STDERR output from SQLCMD.exe
Today while working with a .bat file full of SQLCMDs with really verbose output, I wanted just to capture error messages that were being sent to STDERR without changing the .sql files. I know how to capture/redirect handles in a variety of programming languages, but I haven’t tried to do this in a windows command […]
“SQL Server 2005 Everywhere Edition” Now Called “SQL Server 2005 Compact Edition”
Ahead of the final release in December 2006, Microsoft have released SQL Server Compact Edition RC1. SQL Server 2005 Compact Edition is a very lightweight, in process relational database engine for use in desktop applications and mobile devices. It has an extremely small footprint (~3MB) and minimal overhead. It won’t use any where near as […]