The biggest issue I found in removing NAT is the reduction of privacy. With IPv6 I notice all my LAN devices have a unique public IPv6 address, which allows each device on a LAN to be identified uniquely. Which then allows easier identification of individual devices and users. Privacy implications like the ability to…
Answered Dec 9, 2021 · 1.9K Views Read answer →
Every card uses a chipset from different manufacturers. The Alfa card gets recommended all the time as it uses a chipset (Ralink RT3572 on the V2) compatible with the tools you will be using (aircrack etc). It also has good throughput and if you want to do more than just monitor, e.g Evil Twin etc you will need two…
Answered Dec 8, 2021 · 1.4K Views Read answer →
To solve sql server uppercase you can refer the below mentioned code: declare @a varchar(30); set @a = 'qWeRtY kEyBoArD TEST&''"X'; select stuff(( select ' '+upper(left(T3.V, 1))+lower(stuff(T3.V, 1, 1, '')) from (select cast(replace((select @a as '*' for xml path('')), ' ', '') as xml).query('.')) as T1(X) cross…
Answered Sep 7, 2021 · 3.4K Views Read answer →
Here are the steps to move SQL Server System Database Files - Part 1 Step 1 - Check File Location of System Databases. First, let's see the current location of these files: ... Step 2 - Update System Database File Location. ... Step 3 - Physically Move System Database Files. ... Step 4 - Check Databa
Answered Aug 21, 2021 · 1.0K Views Read answer →
You can use either na1.salesforce.com or mynewname.my.salesforce.com to deploy My Domain and API endpoints. Enabling My Domain is additive - your existing endpoints will continue to work. Having said that, the best practice is to avoid hardcoding the instance wherever possible. Apps should retrieve the instance from…
Answered Aug 10, 2021 · 800 Views Read answer →
Starting with SQL Server 2016 SP1 the Standard Edition supports all functionality most programming surface of the Enterprise Edition, as announced here: SQL server partition Service Pack 1 released !!!. Quoted from that article: The following table compares the list of features that were only available in Enterprise…
Answered Jul 31, 2021 · 2.9K Views Read answer →
To know the difference between SQL Server Datetime Vs DateTime2 you should go through the answer thoroughly. The size of dateTime2(0), dateTime2(1), dateTime2(2), dateTime2(3) use the same amount of storage. (6 Bytes) Would I be correct in saying that I might as well go with dateTime2(3) and gain the benefit of the…
Answered Jul 19, 2021 · 303 Views Read answer →
First thing is to make sure you DO NOT detach that database. Restoring from the last known good backup is fine. Otherwise, you will need to use the EMERGENCY repair mode (I am assuming you are running SQL 2005 or higher). Here are a couple of posts from Paul Randal on the subject. Read them both before you start…
Answered Jul 19, 2021 · 347 Views Read answer →
Git Bash introduces terminal tools that also found in Unix. Download git bash from here: https://git-scm.com/ then select: Download {2.30.0} for Windows (or the latest) Run the downloaded .exe {Git-2.30.0.2-64-bit.exe}Choose a Desktop Icon or not: I prefer Nano as an editor in terminal: I prefer main over master: I…
Answered Jul 19, 2021 · 389 Views Read answer →
I have successfully installed Service Pack 3 on an SQL instance running with the SP1. No test, the install is directly on the production server. Well this is not a complex task and the topic has been already asking for other versions, but I'd like to be sure to not forget some steps and having feedback from…
Answered Jul 16, 2021 · 243 Views Read answer →
Table partitioning is the database process where very large tables are divided into multiple smaller parts. Data in a partitioned table is partitioned based on a single column, the partition column often called the partition key. Only one column can be used as the partition column, but it is possible to use a computed…
Answered Jul 12, 2021 · 294 Views Read answer →
It might depend on what is meant by "too long": Length: If you mean strings of many characters, then try converting some of them to a MAX type (i.e. NVARCHAR(MAX) or VARCHAR(MAX) ). For example: CONVERT(VARCHAR(MAX), 'This is a test ') + CHAR(13) + CHAR(10) + ' string' Concatenations: If you mean operations involving…
Answered Jul 12, 2021 · 237 Views Read answer →
Learners asking and answering questions on the same topics — follow their questions and join in.
Cyber Security learner
159Questions 203AnswersCyber Security learner
147Questions 179AnswersCyber Security learner
133Questions 158AnswersCyber Security learner
107Questions 142AnswersSalesforce learner
103Questions 162AnswersCyber Security learner
97Questions 141AnswersGuides, 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.…
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
