SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
5 answers
SSIS flexible file source Java SE is required to use ORC format
Hi I am trying to read orc files so that I can take the data from them and load into a sql database. I am using the SSIS package that was an addition to SSDT and its an azure addon (SSIS AZURE Feature pack…
asked 2020-09-07T21:36:53.233+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 63%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DAITHI
1
Reputation point
answered 2020-10-14T15:10:29.927+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 70%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Pascal Hasler
1
Reputation point
2 answers
One of the answers was accepted by the question author.
Last 3 full months vs last year same 3 months dates
Hi Guys I am looking for a way to use my date in SQL Server to show me the "last 3 full months vs last year same 3 months dates" not adding the current month - this is something that I want to hard code (Store Proc) and use in SSRS in a Date…
asked 2020-10-14T13:02:14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 56.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
freemont312
21
Reputation points
commented 2020-10-14T14:46:08.493+00:00
freemont312
21
Reputation points
1 answer
One of the answers was accepted by the question author.
sharepoint 2013 - right justify "stop editing and save changes"
Is there a way to right justify the "stop editing and save changes"/ "stop editing this list" text on the page - as I have shown in the attached image? This is normally left justified. I have tried css with no success. See 2…
asked 2020-10-13T21:44:50.373+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
MARCEL BALCAREK
61
Reputation points
accepted 2020-10-14T14:45:48.393+00:00
MARCEL BALCAREK
61
Reputation points
1 answer
Init container in multi-container azure webservice deployment.
We have a docker-compose file with in it 4 containers: Mongo Web App Web Api Initialization When using a multi-container webapp and using our compose file the app keeps restarting. We found this is due to the app being declared unhealthy…
asked 2020-10-13T12:24:34.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 22%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jesse Houwing
1
Reputation point MVP
answered 2020-10-14T14:45:47.243+00:00
Ryan Hill
29,926
Reputation points Microsoft Employee
5 answers
BCD file locked and breaking my backups
Hi all, I have a problem with a client server where backups are being broken. We use Unitrends for backup and everything was working fine until about August 18th. We run Server 2019 Standard and now we are getting backups failing pretty much every…
asked 2020-10-13T20:19:48.917+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 83%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
Brandon Fogliano
136
Reputation points
answered 2020-10-14T14:36:16.377+00:00
Brandon Fogliano
136
Reputation points
2 answers
EXAM FAILURE
what do i do after i failed an exam?
asked 2020-10-14T14:05:22.257+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 9%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
ADEWOYIN DENNIS
1
Reputation point
answered 2020-10-14T14:15:01.317+00:00
Vaibhav Chaudhari
38,896
Reputation points
2 answers
One of the answers was accepted by the question author.
How to add Multiple Case when statement with where condition to get the Attendance Report
I have a table EmpAttendance with the following structure Create Table EmpAttendance (Empid int, EmpName varchar(max), AttendanceDate datetime, IsAttendance bit, IsHoliday bit, IsSick bit, IsDayOff bit) The Table has the following Record INSERT…
asked 2020-10-14T09:39:07.037+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 33%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Polachan Paily
226
Reputation points
accepted 2020-10-14T14:00:24.107+00:00
Polachan Paily
226
Reputation points
5 answers
One of the answers was accepted by the question author.
SCCM displays all results for every folder and/or query
There seems to be a horrible glitch in the SCCM that I inherited. In the folders under Device Collections, all of the collections show for every folder. For example, I have a folder called Servers. When SCCM is working properly, only the server…
asked 2020-10-06T23:11:46.147+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 85%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AgentSmith11
41
Reputation points
commented 2020-10-14T13:52:36.557+00:00
Rahul Jindal [MVP]
10,781
Reputation points MVP
2 answers
Invalid memory pointer read error causing window applicatin crash
Hi, I am analyzing a crash dump of my window application which runs for 3 days and then crashes with "INVALID_POINTER_READ" error. below are the register details: CONTEXT: (.ecxr) rax=0000000000000000 rbx=0000026591824f40…
asked 2020-10-13T04:49:37.047+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 76%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKY%3C/text%3E%3C/svg%3E)
Kunal Yadav
1
Reputation point
answered 2020-10-14T13:49:43.443+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
S.Sengupta
22,456
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Best way to check ccm.log file
I am new to SCCM. In order to troubleshoot Client Push Installation, some fellows have suggested checking the ccm.log file. May I ask what is the best way to check that Log file. Should we remote access the SCCM Server and check the log ? Is it…
asked 2020-10-12T22:56:00.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TonyJK
881
Reputation points
commented 2020-10-14T13:43:41.807+00:00
Jason Sandys
31,406
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
is dbo rights to report users required?
Hi All, I just migrated a few SSRS reports from SQL 2012 to SQL 2016 standard edition using cmd scripts. I have also matched all the accesses from the old to the new including the roles and permissions in the SSRS that includes the site setting and…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
Student discount unavailable for MS certification exams
I am unable to find out if I am eligible for a student discount; I would like to be able to speak with someone about verifying my student email in order to receive a discount for certification exams. I have already linked my student account to my…
asked 2020-10-14T13:22:51.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Antoinette Pryor
6
Reputation points
answered 2020-10-14T13:23:47.223+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
2 answers
3rd screen
pc will not detect my 3rd screen.
asked 2020-10-11T02:18:10.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Armstrong, Jasmine
1
Reputation point
answered 2020-10-14T13:15:50.3+00:00
S.Sengupta
22,456
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Set iOS Devices to Supervised Mode
Hello Community, we want to Rollout iOS Devices in Supervised mode. Our Problem is that we cant get the Devices Synced to Apple Business Manager. The following configurations have been set: We Set up the Enrollment Programm Token a…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 86%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Configuration Manager - Windows 10 Servicing Planing Considerations
SCCM Environment Blockquote A single standalone primary site with many distribution points (DPs distributed on branch offices) Blockquote strong textRequirenment What are the considerations / best practices when planing…
asked 2020-10-13T17:47:05.99+00:00
Chanuka Francis
361
Reputation points
commented 2020-10-14T13:08:08.597+00:00
Chanuka Francis
361
Reputation points
3 answers
One of the answers was accepted by the question author.
207 ERR_CERT_INVALID
Using Microsoft Teams for Linux Mint. When signing in I am re-directed to my organizations sign in page then an error page stating that "We're sorry - we've run into an issue" desktop-6cb4c523-0e5c-46e2-925c-009c58ede7ea Error code - -207…
asked 2020-09-08T17:17:14.787+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 20%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lewis, Austin
96
Reputation points
accepted 2020-10-14T12:57:56.117+00:00
Lewis, Austin
96
Reputation points
1 answer
Azure App Proxy pointing to F5 Load Balancer
Hi, were trying to make internal web apps available thru Azure Application Proxy, but some of our web apps are sitting behind an F5 load balancer. We'd like to make the experience as seamless as possible for our users, so single sign-on is a must. Has…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 64%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
create collections by computer name
Hi,Team. I need to create several collections because of the computer nomenclature. In this example many computers start with "ari" and another one with the word "ari" in the middle. For example aguari003. I know that I…
asked 2020-10-13T21:58:22.963+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rafael Aguilar
496
Reputation points
answered 2020-10-14T11:59:50.973+00:00
Rafael Aguilar
496
Reputation points
2 answers
One of the answers was accepted by the question author.
Access query is running slow from one site
I have two site Site A, Site B. From Site A it takes 20 sec to get the SQL query result but from Site B it takes 30-40 sec for the same query. Both of the sites are on 100MB line. Is they any test I can run to see why its taking longer from site B
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 4%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Install Offline Language Pack on Windows 10 1909
Hi, How can I install a language packs on windows 10 1909 using PowerShell offline? These machines do not have access to Microsoft stores to download the language pack online. What files are needed from the FOD. how do I find which files belong to…