(Nick Lopez) In continuation of the previous blog on needing to provide the server name in your username when connecting, there are other scenarios and new features where this will need to be taken into consideration or make unnecessary!

(Jason Brimhall) In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain sysadmin access. In that article, I made quick mention of restarting SQL Server into single-user mode. It only makes sense to show quickly how to get into single-user mode.

(Jack Vamvas) Question: I’m on a Windows 2016 trying to open Windows Task Scheduler by cmdline – but it’s not opening?Could you lete me know the cmd line reference for opening Windows Task Scheduler?

(Greg Larsen) Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database.

(Pinal Dave) My virtual machines are my playground and I do install/uninstall a lot of stuff there (of course related to SQL Server learning). When things break, I get to learn something new.

(Tibor Karaszi) This post is not about how to use the Activity Monitor (AM) tool in SQL Server Management Studio (SSMS) – there are loads of such posts written already. Also, it is not about dissing AM, you will find such posts as well.

(Sunil Agarwal) A traditional scenario of loading data into CCI is a nightly load from one or more data files containing millions of rows.

(Edwin Sarmiento) In a previous tip on Installing SQL Server vNext CTP1 on Red Hat Linux 7.2, we have read about how we can now install SQL Server 2017 on a Linux operating system. We would like to evaluate running SQL Server 2017 Availability Groups on Linux. How do we go about building the Linux e

(Kenneth Fisher) A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t. Connection only. So how come there are some things that everyone can do once they are connected to a database?

(Manoj) Yesterday my friend pinged me and told that he is facing some issues while executing a SQL Job DDL script. They had upgraded their SQL Server version from 2008 to 2016, and while creating SQL Jobs they were facing below error: