Is there a developer edition of Microsoft SQL Server 2017 for Linux? [closed]
I have SQL Server 2016 Developer Edition installed on Ubuntu, which is free for development purposes: SQL Server 2016 SP1 Developer is a…
1 Answer · 297 Views · Answered ✓
Get a modern-day SQL Developer Training that will help you learn the basics of database querying, Microsoft SQL and the best-practices of Database Management to gain confidence with our Online SQL Certification and surmount a trending career field
I have SQL Server 2016 Developer Edition installed on Ubuntu, which is free for development purposes: SQL Server 2016 SP1 Developer is a…
1 Answer · 297 Views · Answered ✓
I came across an issue today, and while I was able to fix it, I am unsure what caused the issue to happen. I have a column that is Varchar(20). It is…
1 Answer · 747 Views · Answered ✓
I recently started using Management Studio 2012. When using MySQL Workbench, a handy feature was that I could stay all in lowercase and any reserved…
1 Answer · 1.7K Views · Answered ✓
I find that most of my clients are not documenting their databases at all and I find that pretty scary. To introduce some better practices, I would…
1 Answer · 1.2K Views · Answered ✓
The SQL Server instance is accessible and seems to be fine. Microsoft SQL Server 2016 (SP1-CU2) (KB4013106) - 13.0.4422.0 (X64) Mar 6 2017 14:18:16…
1 Answer · 6 Views · Answered ✓
Why does MS SQL Server refuse using supporting filtered indexes in this scenario?-- demo data CREATE TABLE #Test ( ID INT IDENTITY(1,1) NOT NULL…
1 Answer · 2.1K Views · Answered ✓
We need to write the SELECT query results to a csv file. How can it be done using T-SQL in SQL Server 2008 r2? I know that it can be done in SSIS,…
1 Answer · 439 Views · Answered ✓
Even after googling alot i couldn't find the reason for Why do we need to rebuild and reorganize indexes in SQL Server? what does internally happens…
1 Answer · 743 Views · Answered ✓
What are the pros and cons of row-level security?We are porting a database from a desktop app to a web app and want to know the best way to make sure…
1 Answer · 1.6K Views · Answered ✓
I want to search for a string in the names of the columns present in a database.I’m working on a maintenance project and some of the databases I deal…
1 Answer · 1.2K Views · Answered ✓
Here I'm locking several tables. BEGIN TRANSACTION SELECT Top 0 Null FROM TableA with (holdlock, tablockx) SELECT Top 0 Null FROM TableB with…
1 Answer · 1.6K Views · Answered ✓
I've found several sources that state ALTER TABLE ... DROP COLUMN is a meta-data only operation. Is it? Source How can this be? Does the data during…
1 Answer · 667 Views · Answered ✓
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step SQL Server guides from industry experts
Common SQL Server interview questions, answered
Guides, tips and career advice on SQL Server from JanBask experts.
SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts
Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions…
SQL Server How to Become a SQL Database Administrator?
How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn…
SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples
Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system…
SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced
Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.…
Pick another topic to find answers, interview questions, and real-world tips.