Reputation
7,452
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
24 46
Newest
 Enlightened
Impact
~480k people reached

Jan
28
revised Create File,secondary FileGroup then move a table and restore database with 'Primary'
Created code block
Nov
30
comment Returning all rows from multiple partitions of a partitioned table
Partitioning allows you to have a single logical table that is physically distributed based on the key. That way you can query the entire dataset without having to go through UNION gymnastics. Separating it into multiple tables just makes it more difficult to manage in my opinion.
Nov
30
comment Returning all rows from multiple partitions of a partitioned table
Do you have a single table that is partitioned or multiple tables that partition the same data set? If you have a single table that is partitioned, you don't have to do anything with UNION statements.
Nov
25
revised SQL to Find Partial Duplicates of a Field
Added new tags, cleaned up formatting.
Nov
11
answered Can I find out which database is queried on the most?
Nov
10
revised Add users to multiple databases
Added the ability to specify an instance name.
Nov
10
answered Add users to multiple databases
Nov
9
answered Alter DB modify log file for all DBs
Nov
3
comment Configuring SQL Server 2016 to allow remote connections
This is cool, but would recommend using New-NetFirewallRule for this. :) As a pedantic sort of comment.
Nov
3
awarded  Enlightened
Nov
3
comment Configuring SQL Server 2016 to allow remote connections
From the remote machine, can you use Enter-PSSession and connect to the machine(assuming WinRM is enabled on the machine)? Also, just verifying that you ran the firewall rule creation on the machine hosting SQL Server?
Nov
3
awarded  Nice Answer
Oct
25
awarded  Revival
Sep
29
awarded  sql-server-2012
Sep
3
comment Can't restore SQL Server db from full backup, log processing fails, database in 'restoring' state
What error do you get if you run the T-SQL restore script in a query window (RESTORE without using the GUI)?
Aug
3
awarded  Constituent
Aug
3
comment Create an AD user from a SQL Server trigger
There's a lot of potential for security issues here and I would recommend AGAINST this sort of process. It means the SQL Service account has to have rights and you'll execute something like xp_cmdshell (which opens other holes). What's the problem you're trying to solve? Why do you want to create an AD account in this way?
Aug
2
awarded  Enlightened
Aug
1
reviewed Approve mysqli tag wiki excerpt
Aug
1
reviewed Approve mysqli tag wiki