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
Are there any differences from the version of SSMS that comes as part of the SQL Server 2012 Enterprise Installer and the SQL Server Management…
2 Answers · 3.9K Views · Answered ✓
I already know the answer to this but I'll ask anyway. Situation is: SQL 2012 Always On - 2 synchronous replicas. 7 TB worth of Sharepoint DBs in 1…
1 Answer · 1.0K Views · Answered ✓
I recently started using Management Studio 2012. When using MySQL Workbench, a handy feature was that I could stay all in lower case and any reserved…
1 Answer · 3.4K Views · Answered ✓
Let's say I have table NamesTable, which has text index on Name columnDECLARE @String2 NVARCHAR(20) = '"SomeName''*"' SELECT * FROM NamesTable WHERE…
1 Answer · 113 Views · Answered ✓
I found a simple breakout in a where clause in one of our projects where the code is so old that they claim they can't use parameters to communicate…
1 Answer · 2.5K Views · Answered ✓
If local temp tables are only available to the current session, and sp_ExecuteSql creates a new session to execute the dynamic SQL string passed into…
1 Answer · 5.1K Views · Answered ✓
I have 2 table in my database. Table #1 ------------------------------------------------------------------------- | name | family | phone | email |…
1 Answer · 1.6K Views · Answered ✓
I'm using Windows 8.1. I have successfully installed SQL Server Management Studio, but services can't be started in "Sql configuration Manager". I…
1 Answer · 595 Views · Answered ✓
When setting up a new SQL Server, I use the following code to determine a good starting point for the MAXDOP setting:/* This will recommend a MAXDOP…
1 Answer · 1.3K Views · Answered ✓
Quite often when I find resources about XML-RPC vulnerabilities with respect to the xmlrpc.php file commonly found exposed on WordPress sites, I find…
1 Answer · 6 Views · Answered ✓
Quite often when I find resources about XML-RPC vulnerabilities with respect to the xmlrpc.php file commonly found exposed on WordPress sites, I find…
1 Answer · 614 Views · Answered ✓
Justin Schuh defended Google's reasoning in the wake of this post detailing the "discovery" (sic) that passwords saved in the Chrome password manager…
1 Answer · 1.2K 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.
